Generate single table from multiple input files

Question

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,

Vijay_K · Answer

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

Ladarthure · Answer

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 · Answer

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