We have a Run job under flow and that job include total of 60k records, we want to run same job and export 2k unique records based on the two column( Machine name and User ID). Please let us know if there is any function or parameter to achieve this.

[AMiller_Tri]

Hi @Manoj Behera? , thank you for your question.

If the records aren't complete duplications of one another, I'd suggest using the ROWNUMBER() function.

By doing so, and grouping by Machine name+User ID, you'll create a group from each group of records for these 2 columns.

Then, you'll be able to filter and select only records for which rownum==1.

see documentation of this function here

However, you'll need to decide on the sorting. E.G., if there are 5 records with the same Machine name+User ID, which would you choose? The most up-to-date record? or any record would suffice?

I hope that helps,

Please feel free to ask any additional questions.

Thanks,

Amit.