CSV Parser, no headers, hundreds of columns

[dwhansen-cbg]

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.

[christwr]

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

[dwhansen-cbg]

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.

[alchemiz]

I did this for a mapper snap 😀

[anayak]

@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!