Hi @prititit
It is also possible
Do the following
Read the excel file and store in dt1
- Assign as below
file_list = Directory.GetFiles(folderpath)
Loop through each files using for each activitiy.
Inside the loop do the following
assign as below
index = (For row in dt1.Rows
Where item.Contains(row(“Document Title”))
Select dt1.Rows.IndexOf(row))
Now use switch condition with condition as
dt1.Rows(index)(1).ToString
Now different case values:
case1: when dt1.Rows(index)(1).ToString equals No, then use the move file activitiy to move the file to the No folder as follows
From : item
To : “D”+Path.GetFileName(item)
case2: when dt1.Rows(index)(1).ToString equals Collect, then use the move file activitiy to move the file to the No folder as follows
From : item
To : dt1.Rows(index)(1)+""+Path.GetFileName(item)
Regards
Nived N 
Happy Automation 

