Happy Business Starts Here

How to get distinct data by more than one field

Highlighted
Valued Scholar

How to get distinct data by more than one field

Hi,

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

image.png

And this is my data:

image.png

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

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Zuora Staff

Re: How to get distinct data by more than one field

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

Thanks and Regards,
Prem Anandh

View solution in original post

3 REPLIES 3
Highlighted
Zuora Staff

Re: How to get distinct data by more than one field

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

Thanks and Regards,
Prem Anandh

View solution in original post

Highlighted
Partner

Re: How to get distinct data by more than one field

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

Highlighted
Valued Scholar

Re: How to get distinct data by more than one field

Hi @robystan 

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

Regards