How to add matched row to data table?

Hi,
Could you guide me in the following scenario:
I look up for value from one .xlsx in another .xlsx.

If mechanisms return -1 => there is no match
In positive scenario it would return the index of the matched row.

Now i want to add this matched row to a new data table, but i don’t understand how to use properties of Add Data Row activity, bc index changes dynamically.

Thank you!

1 Like

No worries
in Datarow property of add data row mention like this
Inventory_Only3_dt.Rows(Index)

But make sure that the number of columns, order of columns, datatype of all columns of both the datatable are same

Cheers @kuzinyd

1 Like

Hi, @Palaniyappan
I’ve received the following message “message”: "Add Data Row: This row already belongs to another table."
Before my for each i use assign activity to apply same schema to the data table where I store matched row:
FIltered_dt =Remainings_dt.Clone

To clarify the names of datat tables used:

And data table where i store final mathched rows which is FIltered_dt

1 Like

fine in that case
we can do one thing
in ArrayRow Property mention like this
Inventory_Only3_dt.Rows(Index).ItemArray

Cheers @kuzinyd

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.