Multiple column value split to rows

[TE271203]

Hi Team,

We have an excel file where multiple columns has comma separated values. Now, we are trying to split these values to rows and segregate it across each record. Which is causing records to grow like into GBs and its failing while loading it into a target table with space issue.

Source file has only 282 records and used text to columns tool with split to rows option.

Is there a solution and load the data.

Attached design of our job.

Please correct me if i am wrong.

Thank You,

Abdul Rasheed.

[TE271203]

[Qiu]

@TE271203 
We should consider the combination of Transpose and Crosstab for this kind of situation.