I have scenario like i need to add the data to the master excel from different excel file
eg: master file have 20 row
other files have 10 rows each so i need to add all 10 row from each excel file into the master file
Master.xlsx = excel1.xlsx+excel2.xlsx+excel3.xlsx
20 row= 10 row+ 10 row+ 10 row
the result should be 50 rows in the master file
Please Help Me I use append row and merger activity but am not getting the proper OP
I use to merge data tables as well but it’s not working because we have an excel according to the moth we are saving the file
like if today’s run means we are saving the file with today’s name master file or if the file name was changed not equal to today’s month we need to save in a different file