Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Highlighted
Not applicable

Import multiple excel files with columns different

Hi,

I have many excel files, one per month , relating to sales of products in various outlets.

Within each file I have several columns , the first two columns are present in all files , from the third column are the products . Unfortunately , they do not always match the columns of products . I make a brief example :


PV001201501.XLSX

departmentART1ART2ART..n
0011022nn
002510nn
003410nn


PV001201502.XLSX

departmentART3ART4ART..n
001510nn
00275nn
00374nn


PV001201503.XLSX

departmentART1ART3ART..nn
001105nn
00254nn
003510nn


I would get a standard table

DepartmentART1ART2ART3
001202210
002101011
0039017


how can it get?

Thank you!

1 Reply
sinanozdemir
Valued Contributor III

Re: Import multiple excel files with columns different

Hi,

You can force concatenate these files:

Capture.PNG

And in the front-end in a straight table, you can write expressions for each ART:

Capture.PNG

Hope this helps.