Load 'n' columns in QLikview

[#1]

Hi All,

I have an excel which have sales data week wise.

Each week a new week column will be added and the number of columns will not be constant.

I am using a cross table in order to get the sales in single column.

Now the problem is the new columns,so each week i have to add the new week field in the script to get the latest data Manually.

Is there any way to automate it so that the the script can load the newly added field by itself.

Thanks in advance..

Regards,

Reena

[vikasmahajan]

Simply Use  Load  *   from Xls  it will automatically adds newly added columns.

Vikas

[#3]

Yes,

i tried.but the new columns were not loaded when using a cross table.

[anagharao]

Hi,

You could load the table without pivoting it and create columns on the number of values in Month and Week column.

Hope thats useful.