Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

adrianbuzer
Contributor II

Added Columns in Spreadsheet


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

1 Solution

Accepted Solutions
MVP
MVP

Re: Added Columns in Spreadsheet

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!

2 Replies
MVP
MVP

Re: Added Columns in Spreadsheet

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!

adrianbuzer
Contributor II

Re: Added Columns in Spreadsheet

Of course!!

Thanks

Community Browser