Challenge #9 How to Split a string data value using a delimiter into multiple rows in a data column.

Rasha — Sun, 30 Jul 2023 19:07:01 GMT

Hello Incorta fans,

Given a data set as below:

the data source is attached: Group_split_Test.csv

It has a column named value that contains a comma-separated data value grouped by a column namedKey , And it is required to split this single data into multiple rows for each key value.

It should be like that:

Please help me to achieve it 🤷‍ 😀.

Re: Challenge #9 How to Split a string data value using a delimiter into multiple rows in a data column.

Medhat91 — Mon, 31 Jul 2023 13:26:37 GMT

Thanks Rasha,

I found another solution also for splitting data , by sql function ..here is it he function:

SELECT explode(split(col1, ",")) FROM table

try it it works with me.

topic Challenge #9 How to Split a string data value using a delimiter into multiple rows in a data column. in Incorta Conundrums

Challenge #9 How to Split a string data value using a delimiter into multiple rows in a data column.

Re: Challenge #9 How to Split a string data value using a delimiter into multiple rows in a data column.