I have two excel file and i need to update the Input data into Reporting excel sheetw.r.t each column. The column is not fixed in reporting sheet I need to add the condition if any new value is add in the Input sheet so i need to add that column in reporting sheet.See the sample output file for referance.
you can check if a value from your input list is already a column in the Reporting excel, by reading both as DT, and then checking if each “row(“EC”).ToString” is inside ReportingDT.columns.
Attaching the small workflow I built below. If a value is not present, the bot will add a new column to the Reporting DT, with the correct name.
Last thing you’d need to do is add a row, with the numbers you want, on the correct column.
→ This can be easily done with an “Add Data Row” activity.
If your input file is large, For Each Row might not be the most efficient solution!