import csv with junk lines , junk data in some columns as it is.

[sakshim]

I have a text file which has junk lines, data in some of the columns which I have to delete eventually but I need for verification purpose. Also, having multiple lines in 2 columns, Hence, how can I import complete csv as it is in Alteryx. 

[binuacs]

@sakshim use the '\0 delimiter to download the file'

[sakshim]

@binuacs Thankyou for your response. 

'/0' is inserting everything in one column, so I want to import the data in tabular format only.

In a column, cell having multiple lines should get imported in same way.

[binuacs]

@sakshim can you provide a sample input file and expected result to better understand your problem?

[sakshim]

@binuacs , I have attached the data.

I have 2 kind of ask here:

1. Import as is data in tabular format

2. Import only selective columns and discard rest

[lwolfie]

Did you figure this out?  Without seeing a sample of what you want to the end result, my guess would be importing the lines in as they are and then selecting the records that need to separated out with regex and the /n.  Alteryx will import all the columns, but then you would just use the select tool to remove what you don't want.

[dreldrel]

You can import the whole data first, then use the Text To Columns Tool to split the multiple lines into either columns or rows. If this helps, feel free to like the comment