Data Extract of Corresponding Row in a Datatable

image
I am trying to pick each sap_codes corresponding value which is sku_code, sap_code may appear multiple in a single column but I need to consider sap_code once only and pick all of the corresponding sku_code

I am trying with this workflow,
filter_with_sou&productline.xaml (93.7 KB)

image
where I am trying to track the sku code against sap code

Now facing
image

How may I get over from this error and get my expected output?

HI,

If there is possibility that number of result rows is 0, CopyToDataTable shouldn’t be used.
Please use datarow array as the following, for example.

filter_with_sou&productline.xaml (99.4 KB)
Please note that the above xaml is just sample (not tested.)

Regards,