Generate single table from multiple input files

[Vijay_K]

Hi All,

I have a scenario, where i will get multiple files with year data. need to produce single table out of all files.

Note: Data gets repeated in some files but value of the year remains same in all files

Example:

File1

ID   Product     2019 

1       X              100

2       Y                50

File 2

ID   Product   2018     2019       2016

1       X              90        100          60

2       Y              40          50          10

File 3

ID   Product   2017             2019            2020 

1       X              80                100              110

2       Y              30                  50                60

My requirement is to create single table from multiple files

     Final Output

ID   Product   2016        2017     2018     2019       2020

1       X               60         80         90          100        110

2       Y              10          30          50          60          70

Thanks,

[Ladarthure]

Hi @Vijay_K

you could use a batch macro to read all the files, for the input you would need either a directory tool or the filepaths. This done, you could use a summarize to group by your data and get the output you want!

[Vijay_K]

Hi Ladarthur,

when i read multiple files it creates output vertically. my requirement is to create table by picking year information from all files..

thanks

[Ladarthure]

If you can read each file with a file input, you could then use join or join multiple to get the data you need. But basically you can agregate after!

[Vijay_K]

input files are not constant. so i cannot use just join if i get more file