How to Sort the rows of one Data Table based on another Data Table If Both Rows Data Matched then added the entire Data to result Data Table

Help Activities
, ,
1

Hi All

I am trying to Sort the Rows Data in Second Data Table based on first Data Table .

I.e. I have two Data Tables l need to sort the rows of second Data Table based on First Data Table if Both Data Table Rows matched then the Data should paste in result Data Table.

I.e First row Data should search in entire second data table if matches then total rows of first and second table rows should save.
If not matches then first table Data and in the place of second table empty column should be there.

Please someone help me to achieve this.

Thanks in advance.

2

Hi @mettudp075 ,
I think you can use For each row with if
but can you share your file input and expect output?
regards,

3

I can’t use For each row as Data Contains 7000 rows.

Please find reference file.

Expected Output in: Output Sheet
Inputs in Input1 and Input 2

Here I had given Data Set And required output.

sample2.xlsx (9.5 KB)

If you had any solution for this requirement. Please comment.

Thanks in advance