cancel
Showing results for 
Search instead for 
Did you mean: 

CSV Parser, no headers, hundreds of columns

dwhansen-cbg
Contributor

I have a CSV that has hundreds of columns but no headers. This means that I would manually have to add hundreds of columns to the CSV parser snap but this is a huge pain because there are no keyboard shortcuts and I have to manually scroll to the top of the list of columns to click on the “+” button to add a new column. There’s HAS to be a better way. Any help would be appreciated.

4 REPLIES 4

christwr
Contributor III

Maybe you can add a header record upstream, then parse it with headers present?

dwhansen-cbg
Contributor

I ended up exporting the pipeline, opening up the .slp file in a text editor, and copying and pasting them into the .json, then re-uploading the pipeline into the designer. Worked like a charm.

I did this for a mapper snap 😀

anayak
New Contributor III

@alchemiz @dwhansen-cbg When I tried editing json and adding column field values for csv parser, all the column fields went empty when I re-uploaded the file into csv parser. do you know what might be happening.
here’s a post Editing JSON for CSVParser to add hundreds of headers i have created for the same.
thanks!