Using dt.select() with data tables

[Cormac (Cormac White)]

Hello - I am having trouble with the attached workflow where I am trying to use dt.select() functions to add a value from one dt to another dt. I am getting the error Assign: Index was outside the bounds of the array. Can anyone help as to what I am doing wrong?

I have attached the workflow to this question. Thanks in advance. TestProcessDTSelect.zip (28.2 KB)

[Pravin_Patil1 (Pravin Patil)]

@Cormac It is not working because in the assign select condition you are passing wrong arguments.
You should use the expression below and see if that’s your expected output.
ReportDT.Select(“Convert([Model],‘System.String’)='”+row.Item(“MaterialCode”).ToString+“'”)(0)((“Vendor Number”).ToString)

[Cormac (Cormac White)]

Hi @Pravin_Patil1 - I tested your solution but it seems it is looking for a column which doesn’t exist.

[Pravin_Patil1 (Pravin Patil)]

ReportDT.Select(“Convert([Model],‘System.String’)=’”+row.Item(“MaterialCode”).ToString+“’”)(0)((“Vendor Number”).ToString)

Paste this as it is in assign…I think you did some change…The column name I can see in exception I didn’t provide in assign

It is working fine for me. Below output I’m getting