Activity Assign to Select Specific Data to DataTable

Help Studio
, ,
1

Hi,

I have an issue due to my automation.
I have DT" called in_TransactionItem

I would like to Select specific data rows due to condition select “Customer code” =ClientNo
“Customer code” - data column name (before I used "Get row item- “Customer code”
ClientNo- Variable type Generic Value

I used ‘Assign’ activity
SelectedItems = in_TransactionItem.Select(“[Customer code]=‘Client No’”).CopyToDataTable
But it doesn’t work.
Do you have any idea for the value in 'Assign"

2

Hi @PLICHTA_Aleksandra

If you have a screenshot from the table, it would be easier to understand what you need!

But here is a LINQ query, which you can use to get specific data from a data table:

(
From row in in_TransactionItem
Where row(“Customer code”).ToString = Client No
Select row
).CopyToDataTable

For more about Filter DataTable etc. please check the following video:

3

Thank you very much for your reply.
When I used the value, as you wrote, process works correctly.

1 Like
4

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