Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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!

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Not applicable
Author

Of course!!

Thanks