Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Reading new columns from Excel

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?

1 Solution

Accepted Solutions
Not applicable

Re: Reading new columns from Excel

Hi esato,

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

4 Replies
nagaiank
Valued Contributor III

Re: Reading new columns from Excel

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.

Not applicable

Re: Reading new columns from Excel

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

Not applicable

Re: Reading new columns from Excel

Hi esato,

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

Not applicable

Re: Reading new columns from Excel

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

Community Browser