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…!!
You can remove matched rows using filter datatable.
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
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
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.