InvokeCode to filter datatable with where

[Gerardo_Jesus_Ignacio_Vil (Gerardo Jesus Ignacio Villacorta)]

Hello friends, a query, I want to filter a datatable with a large volume of info and that is why I use the InvokeCode activity with VBNet, however, it is generating an error, I already validated and it has nothing to do with the name of columns or data, I would think that maybe it has to do with the “Contains” or “Substring” function that I use inside the where (maybe uipath doesn’t allow this)

The code I use in the InvokeCode activity is:

dt_FraudeBruto.AsEnumerable (). ToList (). where (Function (x) (not x (“FRAUD_TYPE”). ToString.Contains (“VU”)) or (x (“FRAUD_TYPE”). ToString.Substring (0,6 ) .ToString.Equals (“DEBIT”))). ToList (). ForEach (Sub (row) row (“FRAUD_TYPE”) = “DOES NOT MEET THE RULE”)

Give in advance I am very grateful for your attention and support! Thank you!

[asgRPA]

Hola,

Could you try to remove those ToList() items from your query?

[AkshaySandhu (AkshaySingh Sandhu)]

Just surround the invoke activity in try catch and in catch section log a message like:

Log message = exception.InnerException.Message

the above should give the exact error message.

[AkshaySandhu (AkshaySingh Sandhu)]

Also your SubString value is of 6 chars long and you are matching it with 5 chars long string (DEBIT), which is always going to be false.

[Gerardo_Jesus_Ignacio_Vil (Gerardo Jesus Ignacio Villacorta)]

Thank You, with that I resolved the error!