Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Sakura
Contributor

How to add additional columns in Excel source QlikView

My dashboard is running on Excel as source. Previously Excel had 3 columns and now it has 4. I need to accommodate 4th column as well in the dashboard. Please help me getting the data in the dashboard. 

I need to call the sheets as SheetName_* which will bring all the sheets. 

 

 

4 Replies
Support
Support

Re: How to add additional columns in Excel source QlikView

The easiest method to do things is going to be to use the Script Wizard to hit the Excel file again to build the script code, then once you have that, you can copy/paste that back into your original app, that is what I would recommend trying here, should be easier than trying to modify things if you are not very sure of how to do things.  You can also compare the script the Wizard generates and use that to figure out what you need to add to the existing script as well if you do want to just modify things.

The following Design Blog post could possibly help as well, but may be a bit too complex.

https://community.qlik.com/t5/Qlik-Design-Blog/Wildcard-data-loading-blah/ba-p/1467768

Regards,
Brett

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
Highlighted
Sakura
Contributor

Re: How to add additional columns in Excel source QlikView

Thank you for the reply. I am using the wildcard load already. The issue with the data is previously I have loaded 10 files and 11th file has additional column. This is creating synthetic key. 

Support
Support

Re: How to add additional columns in Excel source QlikView

Sorry, I am not a very good developer, so off the top of my head, I am not sure how best to deal with the synthetic key in this case, how to get rid of it, but hopefully now that you have clarified things, someone else may be able to provide you that information.

Cheers,
Brett

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
Sakura
Contributor

Re: How to add additional columns in Excel source QlikView

Thank you for the reply. 

 

For now I have made all the excel files same so that the columns are same number. But I am sure there is some way to solve this kind of situation.