Datatable excel

Help
1

hi, I have two excel, the entry consists of rows of students and columns with courses, in the cell I have the date of completion and I must paste this date in the second excel matching the student and his course

2

HI
welcome to uipath community
we can use LOOKUP DATATABLE ACTIVITY

or we can use for each row loop activity and the steps involved will be like this
–use a excel application scope and pass the file path of first excel
–inside the scope use a READ RANGE activity and get theoutput with a variable of type datatable named dt1
–now again use another excel application scope and pass the file path of second file
–now inside the scope use read range activity and get the output with a variable of type datatable named dt2
–now use a FOR EACH ROW activity and pass dt2 as input and change the variable name from row to row1
–inside this loop use another for each row loop and pass dt1 as input and change the variable name from row to row2
–then inside the inner for each row loop use a IF condition lke this
row1(“yourcolummnname1”).tostring.equals(row2(“yourcolummnname1”).tostring) AND row1(“yourcolummnname2”).tostring.equals(row2(“yourcolummnname2”).tostring)
if this condition passes it will go to THEN part where use assign activity like this
row2(“yourcolumnname3”) = “row1(“yourcolunmnname3”).tostring”
and folllowed by this assign activity use BREAK activity

Cheers @EstelaRPA

1 Like
3

well, thanks, although in the first excel the course comes in the same column and in the second excel each column corresponds to a course (header) and I must copy the date that comes in the cell of the first excel and paste it in the cell of the second Excel matching each student with their course

4

yah these steps does the same
did that help you resolve this using FOR EACH ROW loop

Cheers @EstelaRPA