For each row in data table,select respective files (contains row)from folder and append each row data to the top in file

Help Studio
, ,
1

Hi,
@Anil_G
Please help me in getting my requirement done in UiPath, my requirement is as follows.
1)I have an excel file with multiple rows of names (A, B, C,D,E) &
2)I want to select all files in a different folder(Folder Path) which contains row name like (A_Test.csv, B_Test2.csv, C_Test3.csv,D_Test4.csv,).
3)write each row data to the top of each file.
Please find the attached test file for reference.
test.xlsx (8.8 KB)

2

Can you elaborate more of 2 point or else share the expected out put, so it’s easy

@POOJA_MARUTI_BALIGIDE

3

@Praveen_Mudhiraj
Please find the input file and Output file as A& B.
test.xlsx (8.8 KB)

A.xlsx (8.7 KB)
B.xlsx (8.7 KB)

Note. A& B are already existing files. only the row data from each row has to be append in the top of each file

4

@POOJA_MARUTI_BALIGIDE

exceldata.zip (3.2 KB)

the no of rows in the test.xlsx should be equal to the no of files then this will work

i have a created a folder and tested for only 2 files its working just place the remaining files like C.xlsx,D.xlsx,E.xlsx

cheers

1 Like
5

@Shiva_Nikhil ,

Thank you so much for quick reply.

And yes , as u said the no of rows should be equal to no of files .

I will test the solution and update you soon.

2 Likes
6

@Shiva_Nikhil ,
Solution is working with excel files.&
For each row in data table ,I want to write data row to the respective csv files to the top.

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.