How to join datatables based on row?

The result datatable from a Bulk Add Queue Items contains RowNumber, ErrorMessage, and ErrorCode.

image

I want to join this with the actual datatable that was given to the Bulk Add Queue Items activity.

I figure I can loop through the original datatable and fill in a RowNumber column and then join with that, but is there an easier way?

something like this probably. initialize a DT with autoincrementing column and merge. Prevents looping

1 Like