Help with code for flow decision

[thomasb82 (Thomas)]

Hey guys,

Im stuck on wanting this to work(could solve this another way but i kinda want to do it this way).

I’ve got a datarow(in_transactionItem) argument containing 10 columns. Then i’ve got a datatable(in_DT_SignalerDel2) containins 2 rows of numbers.

In the flow decision, i want to check if the datarow column 8 contains any of the numbers in the Datatable. If so the statement is True and it will continue down that path.
So far i’ve got this:

in_TransactionItem(8).tostring.contains(in_DT_SignalerDel2.AsEnumerable().Any(function(r) r(“Col1”).ToString().StartsWith(“2020”)

However the error message says" ) expected". Could anyone just give it a quick check as to what is wrong with the code?

thanks,
T

[Anil_G (Anil Gorthi)]

@thomasb82

in_TransactionItem(8).tostring.contains(in_DT_SignalerDel2.AsEnumerable().Any(function(r) r(“Col1”).ToString().StartsWith(“2020”)

Hi @thomasb82

Try this

in_DT_SignalerDel2.AsEnumerable().Where(function(r) r(“Col1”).ToString.Contains(in_TransactionItem(8).tostring)).count > 0

This will get rows which are matched and > 0 will check if there are any returned or not

cheers

[thomasb82 (Thomas)]

@Anil_G

in_DT_SignalerDel2.AsEnumerable().Where(function(r) r(“Col1”).ToString.Contains(in_TransactionItem(8).tostring)).count > 0

Works! Thanks!