I have a table as follow:
I have filtered the Excel table for each user, generating four output Excel files, i.e. one file per ‘Name’. Now I need to send those files to their corresponding email addresses. For the file with ‘Name1’, having two rows, it’s sending the same file twice to ‘email@example.com’. It should be sent only once. I tried those properties for distinct values, such as ‘arrayVariable.Distinct().ToArray()’ and 'table.DefaultView.ToTable(True,“Email”) but no success.
Any help with this? Cheers!
Read only column A and B. (Range “A:B”) then use Remove duplicate rows activity.
I do not know for you but it works.
you can find attached sample reference - FindduplicatesInDT.xaml (10.4 KB)
Thanks. It works just fine
One quick question: suppose if I have a fourth column (columnD) holding other values, let’s call it Value2. How to send those emails only if Value2-Value1 <= 1000?
Sorry, just learning UiPath and every information here in this forum is a great help.
Thanks for the example, very useful.