Hello community
Can you help me configure the activity correctly so that it gives me what I need?
I need to return the index of the line where the value in the “Invoice” column contains “credit note”
Contains “credit note” would not work with lookup as it is “looking up” exact values.
I suggest you just loop trough your datatable using a “For each row” activity and there you can use currentrow(“Invoice”).ToString.Contains(“credit note”) to check if the column invoice contains “credit note”
- If contains then lookup cannot be used…it works with exact match…else just give the column name you want to searcha nd the value in value field you would get output
- if you need with contains only then try this
dt.Rows.IndexOf(dt.AsEnumerable.Where(function(x) x("Invoice").ToString.ToLower.Contains("credit note")).First)
cheers