Dt Values

Help Studio
, ,
1

Hi,

If I am looking for specific values (“S”, “NQ”) within a transaction item that is a variable type of data row without specific column names, what would the expression be?

2

Hi @Gideoso

Try the below expression

-> Assign -> filteredValues = transactionItem.ItemArray.Where(Function(value) {"S", "NQ"}.Contains(value.ToString)).ToArray

filteredValues is of DataType Array of Objects

1 Like
3

Hi,

Can you share what you need as result? For example, True or False, index number of column or value “S” or “NQ”?

Regards,

4

What would the expression then translate into a Boolean type for an IF activity?

5

Hi @Gideoso

-> Assign -> filteredValues = transactionItem.ItemArray.Where(Function(value) {"S", "NQ"}.Contains(value.ToString)).ToArray

If filteredValues.Length > 0 
Then
    ' Your code when condition is true
Else
    ' Your code when condition is false
End If

Hope it helps