Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

1 to many match from a list

abalandin123
Level 1
Level 1

Hello,

I have many schemas that are mapped to external SQL tables. I have an external SQL table that has all of my contact information for our clients. I am trying to upload a file with many Zip codes and I am trying to find all of my contacts in my contact master table with those zip codes. What is the best way to go about it? I tried loading in a List read and then adding an enrichment data with the contact master table and doing a 1 to N match on zips, with no luck.

0 Replies