Dataflux 2.8 - How to look up a value to see if it exists in a list from another row

[beamer108]

I have created lists that contain addresses for each member in our database.  If a new record comes in, I want to search on that list to see if the address currently exists or is new.  A member could have multiple addresses in their list ie Mailing addr, home addr etc. 

Im assuming it needs to be in an expression node but just not sure how to do it.  Currently the datajob is using a match code node but realizing now that if the list contains multiple addresses separated by a ';' the match code is only creating a encode for the first address listed so any other address is not being matched. 

TIA

[audrey]

This seems a bit complex to be diagnosed in the forum. I think you'd need a join, and probably match codes for each of your addresses, but I'd to see the current job and maybe a sample of how your data is stored to be sure.

Are you able to send any of this here? If not, I'd suggest opening a ticket with Technical Support by email at support@sas.com.

Thanks,
Audrey