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: 
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
Author

Hi esato,

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

View solution in original post

4 Replies
nagaiank
Specialist III
Specialist III

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
Author

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

Not applicable
Author

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
Author

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