topic Re: How to load data from different excel in qliksense in Connectivity & Data Prep

How to load data from different excel in qliksense

LP27 — Wed, 15 Dec 2021 18:49:32 GMT

Hi Qlikers,

I am new to Qlik sense environment, I have got 11 Excel(xlsx) files under same folder. Each excel file represents each month data. I need to load all these excel files automatically into to the data load editor, but only columns from A to N from all these files will be needed and all the column header from A-N is same in all the Excel files(xlsx).

Is there a possible way to to do this task ?

If so, could some one guide me please!

Note : I am beginner[Take it easy]

Help will be appreciated in this matter !

Re: How to load data from different excel in qliksense

Lisa_P — Thu, 30 May 2019 22:29:49 GMT

It should be quite simple. Are the file names similar ?
Try starting with one file and load the fields/columns that you want. Test this and check the results.
Then you can just edit the script using the Data Load Editor to get the data from all of the excel files. If they have the same start of file name, you can use that with a wildcard at the end and it will bring all the data into one table.
eg
Load FieldName1,
FieldName2,
.
.
.
From ....... file*.xlsx;

Re: How to load data from different excel in qliksense

LP27 — Fri, 31 May 2019 07:12:34 GMT

Thanks Lisa_P, It worked.