Reading new columns from Excel

[#1]

Current Excel data source has columns for three dimensions and three measures.

User wants to add new column(s) in Excel to add new measures.

How would this be done in QlikView so that I don't need to make changes to QV application, when user is adding data to a new column?

Example of current data:

Product, Customer, Region, Qty, Profit, Price

Prod1, Cust1, US, 5, 3.2, 6.4

Prod1, Cust2, EU, 19, 3.5, 6.4

Prod2, Cust1, US, 3, 0.9, 3.4

Prod3, Cust2, EU, 14, 1.5, 8.34

And user wants to add later i.e. Delivery costs or Discounts or what ever columns comes to his mind. And I, being lazy, want to automate it.

Any ideas on how to do it?

[nagaiank]

If new columns are added (appended) at the end of the existing columns, you can still use the same spreadsheet without modifying your script if you do not use the new fields.

You need to change the script only if you want to load the new fields into your application. You may have to change the application anyway, if you want to use the new fields.

[#3]

Case is, those new columns should be added to application automatically.

[#4 · Accepted solution]

Hi esato,

Use Load *, instead of listing the field names in the script, this will load all the columns available in the sheet.

[#5]

Thanks arasu.valan. I have to work some script to read column names and so on, but this helped me over the first obstacle.