I have two excels as Master and Sample.
In Sample Excel they are specific rows(like 20) in one column by using these rows, I want fetch that rows in Master Excel which contains More than 1 lakh records. How can I do this, Looking for quick help.
Please follow the below steps and see if it suits your requirement.
Use workbook read range activity and input your master excel with 1 lakh data and store the total rows into a datatable MasterDT
Follow the same steps for sample excel store the information into a datatable SampleDT.
Now use for each row activity assign the sample DT. I assume your mentioned column name values should have identical or similar values in the master.
In side for each loop use filter data table activity assign your masterDT and filter the columnname with the sample DT value like currentRow(“columnname”).tostring to match the records in masterDT. Use different datatable to store the output. Now we have filtered records in dt.
Use merge datatable activity to merge datatable values to form a final datatable only with matched records with the sample.
With the use of for each loop we can iterate 20 times bcz of sample file data and get our desired output in final datatable.
After the for each row loop you can use workbook write range activity to wrote the filtered data in different excel or different sheet in master excel.
thanks for your inputs Robin,
I didn’t get this Use if activity to check the samplerow(“columnname”)=masterrow(“columnname”). I need to assign variables as samplerow n masterrow? If i’m wrong correct me.