Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
quad4x
Contributor II
Contributor II

distinct email sets through tFlowToIterate without multiple DB query

I'm currently trying to grab data with associated email addresses and email each individual with data from that query.  Since I do not want to email the same person multiple times,I first query to get all the unique emails.

 

With the set of unique emails I then run through

tUniqRow->tFlowToIterate->DB input->tFilterRow->tJavaFlex->tSendMail

 

This works and I get the data for each unique email, but it also has the downside of having to query on the DB input each time for each email.

 

Is there a way to iterate through a set of emails and only do the query once?

 

Labels (3)
0 Replies