You can translate the question and the replies:

Filtering out duplicate values

I am using ITPilot Wrapper Tool to grab clients report numbers, navigate to a URL to get their data (name and email), and input it in a website that then sends them an email requesting them to do a certain task for us. My problem is we have clients with the same report numbers duplicated in our system (there is a reason for this and it is not the problem). However, they only need one email sent to them even though they may be in the system more than once. So my questions is how can I filter the duplicate report numbers (data) from being output? As it stands currently if I were to run my tool many of our clients would receive two emails instead of just one. So I need to filter the inputs for the email sequence so that it just sends one email. Thanks!
User
13-06-2022 14:29:40 -0400

1 Answer

Hi, Depending on the actual implementation, it may be possible to use something like a list variable to store the intermediate values. When your iterator goes through that variable, to read the final email addresses, based on whether the email already appeared or not it would either skip it or add it. However, notice that [ITPilot](https://community.denodo.com/docs/html/browse/8.0/en/platform/upgrade/features_deprecated#itpilot) is a deprecated component, so if the source offers an API, I would try to implement that use case without ITPilot by VDP only. That way, you would be able to use a DISTINCT clause in order to not get duplicate email addresses and use those values as input for sending the mails. If you have a valid support user, I would recommend to [open a support case](https://support.denodo.com/) for that scenario so that it can be reviewed in more detail with the Denodo team. Hope this helps!
Denodo Team
14-06-2022 10:56:08 -0400
You must sign in to add an answer. If you do not have an account, you can register here