I want get distinct rows on the basis of two columns

I want get distinct rows on the basis of two columns.
so that i can only iterate distinct rows, please help with the query.

Hi @UiPathMaster,

To iterate through distinct rows in a datatable on the basis of 2 columns, use the expression YourDatatableName.DefaultView.ToTable(true,"Column1_Name","Column2_Name") in the input filed of “For Each Row” activity. :slightly_smiling_face:

Regards,
Nimin

3 Likes

I have already implemented this but this gives only two columns.

This link may help you,

AND,