How to get distinct data by more than one field

[salmdo]

Hi,

In the workflow, I see that we can get distinct data by 1 field.

And this is my data:

I would like to get a distinct account by Name AND Currency. How can I do it in my workflow?

Thanks

[pramamoorthy · Accepted solution]

Hi Salmdo, 

Can you use Data Query task instead of Export? 
In Data Query you can easily make it group by or distinict. 

Thanks,

Prem

[robystan]

I used the distinct in the WF, 2 months ago it worked. Now I receive: Query failed: window does not support distinct

[salmdo]

Hi @robystan 

It still works with me, I think you need to send a request to support team.

Regards