I have an **Excel file-1.xlsx (3.0 MB) ** to be filled. I have data in excel file-2. Excel file-2.xlsx (112.2 KB) I want to fetch the data from excel file-2 and fill it in excel-1 And I am using LookUp Datatable activity to fill the data(clientwise data).
The robot is able to fill the data but it is taking longer time which is more than an hour for just 5 clients
Now I want to fill the data for 60 clients… I don’t know how to proceed further.
In my code, I have used only one LookUp Datatable activity to fill the 5 clients data (which is around 459 rows).
My Excel file-1 & Excel file-2 are attached below for your reference.
Excel file-1 : I want to fill the column P in this file.
excel file-2 :
Column P values to be filled based on SALES PREMIUM column from the file.
Excel file-2 shown below for your reference
I have filled only 5 clients using single lookUp datatable activity. but taking longer time.
The five clients data to be filled are
5. HCI(Home credit)
Excel file-2 has all the formulas, which I wanted to fill it into excel-1 columns
For eg., For Erafone, I want to fill it in column P(GMV Erafone) in my excel file-1
similarly, for XL-Era client, I want to fill GMV XL-Era which is Column AC
Please do the needful I want to do it for 60 clients. Please provide me some idea on how to fill for 60 clients using single lookup datatable activity in less time