Added Columns in Spreadsheet

[Anonymous]

I am loading an excel spreadsheet into Qlikview using a crosstable script.  Each column across the top of the spreadsheet is for a different supplier. If a new supplier was added (and hence a new column in the spreadsheet) is there anything I can add to my script that will pick that up automatically?

Thanks

[Oleg_Troyansky · Accepted solution]

simply replace the explicit list of fields in your load by an asterisk "*", like this:

Instead of:

CROSSTABLE(...)

LOAD

     Field1,

     Field2,

     ...

FROM

...

Use:

CROSSTABLE(...)

LOAD

     *

FROM

...

All new fields will get loaded automatically.

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

[Anonymous]

Of course!!

Thanks