Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to load multiple Excel sheet which are having different column name?

Hi,

I have three Excel sheet which having different column name also.

How to load them?

Thanks

Tanushree Roy

2 Replies

Re: How to load multiple Excel sheet which are having different column name?

gompa786
Contributor III

Re: How to load multiple Excel sheet which are having different column name?

Hi,

If you are using Qlik sense desktop. You can drag and drop the file in an app and while dropping it will ask you to choose the sheet and you can do it three times for the three sheets if you don't want to use looping.. Then you can insert the script and load the data once you are finished with all the three tabs... Hope this helps..

Thanks

Community Browser