Hello guys, how to find data from DataTable that have same values; ex: people that have same address?

Help Studio
, , , ,
1

image

2

Hi,

Hope the following helps you

img20211107-4
img20211107-4721×603 16.9 KB

Sample20211107-1.zip (2.9 KB)

Regards,

1 Like
3

@Shamsa_Abd

Welcome to our UiPath community.

  1. Use Read Range activity to read the data from excel file and it will give output as DataTable. Let’s say InputDT.

  2. And then try below expression to get unique Addresses.

     UniqueAddressDT = InputDT.DefaultView.ToTable(True,"Address")

  3. And then use ForEach Row activity.

       ForEach row in UniqueAddressDT
         PeopleDT = InputDT.AsEnumerable.Where(Function(x) x("Address").ToString.Trim.ToLower.Equals(row("Address").ToString.Trim.ToLower).CopyToDataTable

Here, PeopleDT contains all users whose address is same.

5

Thanks @Yoichi ,it works. How to write all output in specified cell instead of message box? or even in specified column ?

image

6

Thanks @lakshman, what is x ? the expression of PeopleDT has an error

image
image916×224 11.5 KB

7

Hi,

How about the following?

img20211107-5
img20211107-5692×451 13.8 KB

Sample20211107-1v2.zip (3.3 KB)

Regards,

1 Like
8

Great, thanks @Yoichi for your quick help, appreciated.

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.