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