You are viewing limited content. For full access, please sign in.

Question

Question

Merging Multiple Fields into One

asked on September 18, 2019

What's in RED is my goal (to take all Display Names, do a lookup to pull email addresses, and place email addressed in the emails field):

As you can see, I'm close. The problems is that it's choosing one name and putting in over and over again and NOT eliminating duplicates. Here's how I've set this up:


What am I doing wrong?

0 0

Replies

replied on September 19, 2019

You're using %(Searchrepository_originator) in your query rather than the For Each Entry's current value for that field. So you're always looking for the first search results's data.

1 0
replied on September 18, 2019

The first thing I'd say is that the remove duplicates function should not happen until after all of the loops. The way it is now, it seems like it is trying to remove duplicates from the current value in the for each row token, which should only be a single value anyway. What you should do is have an activity that removes duplicates from the Emails token after both loops are complete and the list is built.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.