Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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