How to filter multi condtion with multi column

Help Studio
, , ,
21

assign activity:
LHS: Result | DataType: List(Of Datarow) =

(From d in dtData.AsEnumerable
Let hasKey = arrColSet.Any(Function (x) arrKeys.Any(Function (k) d(x).toString.Contains(k)))
Where not hasKey
Let isDist = arrColSet.Select(Function (x) d(x).toString.Trim).Distinct().Count = arrColSet.Length
Where isDist
Select r=d).ToList

then check within an if acitvity
Result.Count > 0
Then: dtResult = Result.CopyToDataTable
Else: dtResult = dtData.Clone

1 Like
22

image
image1076×484 22.6 KB

23

just share some more details with us related to the loop over the data table. Maybe a different name for the looped data row is used

24

i not used any loop here, Can i used for loop

25

maybe this will help

26

then please share more details on what you have implemented so far, Thanks

27

EXcel cpt code.xaml (10.0 KB)

One more thing i want to add, how to add header in this

28

give a try on replacing row with d
Let isDist = arrColSet.Select(Function (x) d(x).toString.Trim).Distinct().Count = arrColSet.Length

29

image

30

image

31

ensure following pattern

32

done thankyou,
Can you guide me to the next step?

33

I want only CPT with values, we have to remove empty CPT,
after that, I have to paste in new excel with the header.

34

sorry but i get null value in result dt (finalDt)

image
image1312×798 35.7 KB

35

hi please see the above issue.

36

Can you help me on this, i did not get any data here.

37

just go again through the posts and recap what was done. Especially check out the defensive approach for handling empty filter results.

dr prefix we use for data row
dt prefix we can use for data table

so just do a more clear variable naming in your implementation. In case of the issue is existing go for debugging the code and check the statements within the different options as presented here:
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum