Select dt question

[andreus91]

Hi all,

i’ve the following report:

I would like to know whether, within the dt, there are KO rows in the execution state column, and, of the KO columns, exclude those containing the letter ‘B’ in the ‘Notes’ column.

just to clarify, in the notes column I should exclude all those that CONTAIN the letter b.

Thank you in advance

[Anil_G (Anil Gorthi)]

Hi @andreus91

read the data into a datatable(dt)

dt.AsEnumerable().Where(function(x) x("Execution state").ToString.Equals("KO") and x("Note").ToString.ToLower.Contains("b")).count > 0

Here I used >0 after count to check if at least one row is returned

cheers

[RajKumar_DC (RajKumar Durai)]

Hi @andreus91,

You can also solve this using Activity like below workflow

Workflow

Thanks,
Rajkumar