Problem with added columns in CSV

Fri, 07 Jan 2011 10:53:44 GMT

Our developers have added more columns to our CSV files. This cause the script to crash due to the fact that the new columns are missing in older csv files.

Is there a way to check if the column exist or can I ignore columns before a certain date somehow?

I need the data in the new columns, but I want to load the old data as well.

Niklas

Problem with added columns in CSV

jonathandienst — Fri, 07 Jan 2011 11:01:22 GMT

Niklas

You may be able to solve your problem using column numbers rather than headings in your script.

Something like:

LOAD
@1 AS Id,
@2 AS Name,
@3 AS Date
FROM DataFile.csv;

This should get nulls for columns that do not exist. This does assume that the columns were added to the end of the csv. If they were added in the middle, then you will need a more complex approach.

Jonathan

topic Problem with added columns in CSV in QlikView

Problem with added columns in CSV

Problem with added columns in CSV