topic Re: Added Columns in Spreadsheet in QlikView

Added Columns in Spreadsheet

Anonymous — Thu, 23 Apr 2015 14:41:11 GMT

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

Re: Added Columns in Spreadsheet

Oleg_Troyansky — Thu, 23 Apr 2015 15:04:07 GMT

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!

Re: Added Columns in Spreadsheet

Anonymous — Thu, 23 Apr 2015 15:50:26 GMT

Of course!!

Thanks