Find new columns

[Anonymous]

Hi guys, I need of your help.

Suppose I have an xls file with 4 columns this month, and I load each one.

Next month I receive a new xls file, with the same four columns, plus new one.

Can I write a script to tell me that there is a new colum?

Otherwise is there a way to make the system tell me if there is one or more new columns?

Thank you

[marcus_sommer]

You could load your tables with a wildcard like:

load * from ...

which would include new columns without knowing the fieldnames whereby I assume that your source is a kind of crosstable by which a transforming into normal datastructures is often useful, see: The Crosstable Load.

- Marcus