Loop through file names including date

Help
1

Hi everyone!!! I am starter of Uipath. My basic need was to combine 2 excels which represent daily data of two companies and paste them into another excel file. I used “Append range” and was able to combine excel sheets. I have to do this combine for a month (about 30 days) and all file names includes date of data. Therefore, I need to create loop and change date, which is in the file name, to variable. I thought to create string variable as start date like “01/08/2019” that I can change manually, because year and month does not have pattern. After I give start date, I need to combine the files for every date+1 (01-30/08/2019). I could not create loop and stuck. Could you help? So i can continue to learn and explore :stuck_out_tongue:

2

so basically,…you are combining two excel sheets …day wise …??
excel 1 -----01/08//2019 combine with excel 2------01/08/2019
excel 1------02/08/2019 combine with excel 2-------02/08/2019
…
…

3

Hi @koksala
Are the columns unique because its different it is a different story

Thanks
Ashwin S

4

columns are unique

5

yes, i combine like you said and paste into another excel

6

Hi @koksala
Use Build Datatable activity
and use add data row and use write range
(or)

Use Merge Datatable Activity

Thanks
Ashwin S