How to use nested for each loop in mentioned Scenario?

[supermanPunch (Arpan)]

@Prabin_Chand

Actual Requirement: I need to compare two column from two different sheets and if match is found need to copy the cell value and paste into another work sheet on the comparing sheet and if value is not match leave the cell empty and repeat the process.

Hi @Prabin_Chand ,

Could you maybe provide input and Output example data for this Scenario? If you could provide us the Excel Sheets it would be quicker for us to assess the logic and provide you a better solution.

On a glance of your requirement, it does seem that you could perform these task using Join Datatables Activity as well, and then performing the required update using a Single For Each Activity.

A Similar Logic is used in the below Post :

Linq query compare datatable

Hi @Manikandasamy , Could you Check the Workflow Below : DT_Compare_UpdateRemarks.zip (16.4 KB) The Workflow uses Join Datatable Activity to join the Datatables based on the Name column. We then add the new Columns Required. Next, Loop through the rows of the Datatable using a For Each Row Activity and update the Remarks Column. We also define the Output Column Names required to be preserved in the Output Datatable in an array. For Converting the Number to Words assuming that is what was …

Let us know if this doesn’t help.