Csv parser - Evaluate header for each file

Hi,

 

I have multiple CSV files in a directory. They may have different column combinations, but I would like to COPY them all with a single command. But the FDelimitedParser only evaluates the header row for the first file, then rejects all rows that do not fit - ie. all rows from most of the other files.

 

1 - Is this expected behavior, and if so, why ?

 

2 - I want it to evaluate the headers for each file, is there a way ?

 

Thanks

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file