LINQ to combine multiple files to match template format

Help Studio
1

Hello Team,

Is there a LINQ method to combine multiple large files and the output will match the template? I am enclosing the 10 input files and the file with the desired output.

Thank you in advance
Regards,
PPIM
CM_Report 1.xlsx (797.1 KB)
CM_Report 2.xlsx (456.1 KB)
CM_Report 3.xlsx (529.8 KB)
CM_Report 4.xlsx (459.5 KB)
CM_Report 5.xlsx (524.2 KB)
CM_Report 6.xlsx (210.9 KB)
CM_Report 7.xlsx (449.0 KB)
CM_Report 8.xlsx (462.7 KB)
CM_Report 9.xlsx (523.2 KB)
CM_Report 10.xlsx (645.8 KB)
Output Format.xlsx (125.9 KB)

2

@PPIM_RPA

You can use for each file activity and then inside that use read range and merge datatable activity to merge all the data together …data manipulation as per your output column needs to be done by adding columns where needed using add data column activity and then use write range to write to required excel

you dont need linq for this

cheers

3

from the samples we would assume that the different tables are to join on a ccolumn (e.g. Location ID)

If so merge datatable will not create directly the expected output as the different rows of same Location ID are to flatten

Another option is to Join the data by the common join column