Datatable contains particular string

[Rishik_Chowdary]

Hi,

Good Day…!!

I have an scenario like if A or B or C only exists in datatable(Excel) i want to skip that datatable. Attached snapshot below

2- If there is any combination with A or B or C with different data I want to take that particular scenario and continue the process. Attached snapshot below

Hope You Understand…!!

Thanks,
Rishi

[Rishik_Chowdary]

++

@mukeshkala @ppr @nikhil.girish @Nithinkrishna @Gokul001 @Palaniyappan @Rahul_Unnikrishnan @THIRU_NANI

[muhammedyuzuak]

Hi @Rishik_Chowdary,

You can remove matched rows using filter datatable.

Regards,
MY

[Srini84 (Srinivas Kadamati)]

@Rishik_Chowdary

As @muhammedyuzuak said you can filter rows as above

Now use If Condition and write as Datatable.Rows.Count > 0 then it means you have other values without A,B or C

That way you can define your logic

Hope this may help you

Thanks

[jack.chan]

@Rishik_Chowdary
alternative
check if

String.Join("", dt.AsEnumerable.select(function(row) row("Name").ToString).Distinct().tolist().OrderBy(function(x) x)).Equals("ABC")

(where dt = your datatable)

if true = proceed, else skip

e

[30f3f2f862699c8f0019492ed (Bala Ralid)]

@Rishik_Chowdary
You can use for each row activity and If activity inside for each.
Give If condition as CurrentRow(“Name”).ToString.Equals(“A”) Or CurrentRow(“Name”).ToString.Equals(“B”) Or CurrentRow(“Name”).ToString.Equals(“C”)

you can build your set of activity in else block as how you want to proceed.
Regards
BM