Hello,
I am new to Uipath, I have excel file with three columns as below
1-“empID”
2- “Dept”
3-“Location”
All employee files name empID are located in main directory.
I have to move each empID’s file to its relevant dept. folder (Location) based on column 2 (Dept).
Please help to find the solution.
I think your process is a typical RPA process.
At least, you need 3 steps to implement your process.
First, use the Read Range activity to get table data which includes three columns.
Second, use the For Each Row to get the values of three column from each row.
Third, use the Move File activity with empID and Location in For Each Row container to move file to each correct folder.
@lakshman@wusiyangjia@Yoichi
Thanks for the reply, please note i need to move employee’s files(column “empID”) from Main Folder to their Department’s folder based on excel column #2 (column “Dept”). The department folder path mentioned in column 3 (“Location”).
Thanks.
I am getting same error “Move File: Index was outside the bounds of the array”.
I have multiple pdf files( "empID1 ,"empID2 , "empID3, “empID4” etc) in common folder.
I need BOT to read excel column “empID” and move the pdf file from common folder to the path mentioned in Column “Location”.
As per below code it moves only 1st file to its correct location and then throws the error msg. as “Move File: Index was outside the bounds of the array”