Import multiple excel files with columns different

Fri, 04 Mar 2016 16:44:11 GMT

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

department	ART1	ART2	ART..n
001	10	22	nn
002	5	10	nn
003	4	10	nn

PV001201502.XLSX

department	ART3	ART4	ART..n
001	5	10	nn
002	7	5	nn
003	7	4	nn

PV001201503.XLSX

department	ART1	ART3	ART..nn
001	10	5	nn
002	5	4	nn
003	5	10	nn

I would get a standard table

Department	ART1	ART2	ART3
001	20	22	10
002	10	10	11
003	9	0	17

how can it get?

Thank you!

Re: Import multiple excel files with columns different

sinanozdemir — Fri, 04 Mar 2016 22:00:01 GMT

Hi,

You can force concatenate these files:

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

Hope this helps.

topic Re: Import multiple excel files with columns different in Connectivity & Data Prep

Import multiple excel files with columns different

Re: Import multiple excel files with columns different