CSV file data from one column to multiple columns

[saikumar (saikumarrao)]

Hi Everyone… I have a CSV file having data in one column only, Data have to be split from one column to Multiple columns…
Here is my Input screenshot

Output as to be

Thanks!!!

[TimK (Tim Kok)]

Can you open your file in notepad and share screenshot of that, a csv must be delimited by something in order to section correctly.

Your current input(first image) is very difficult to split accurately / efficiently because there is no identifiable delimiter

[saikumar (saikumarrao)]

Hi @TimK…Can i share my inpute csv file!!

Thanks

[TimK (Tim Kok)]

Sure

Can you upload it or can you put it on a google drive or fileshare?

[TimK (Tim Kok)]

Hey
So you can use Read CSV activity, and in the properties panel change delimiter to Tab

[saikumar (saikumarrao)]

Thanks @TimK…It’s working…!!!