Pipeline - extract distinct values from table.
Hello,
I have Positions table in my app. In each position user should fulfill the email field of user assigned to this position. Now I'd like to extract all emails I have in this table to csv file. I'd like to do it automatically. I found a way to achieve it with pipeline.
Currently I am extracting all records so all emails.
I don't need duplicated emails, I mean when xx@email.com is assigned to 3 positions I need this email only once.
Is there a way to search only for distinct emails in Search Records step or in any other?
------------------------------
Piotr Kryszkiewicz
------------------------------
I have Positions table in my app. In each position user should fulfill the email field of user assigned to this position. Now I'd like to extract all emails I have in this table to csv file. I'd like to do it automatically. I found a way to achieve it with pipeline.
Currently I am extracting all records so all emails.
I don't need duplicated emails, I mean when xx@email.com is assigned to 3 positions I need this email only once.
Is there a way to search only for distinct emails in Search Records step or in any other?
------------------------------
Piotr Kryszkiewicz
------------------------------