https://communities.sas.com/t5/SAS-Data-Management/Dataflux-2-8-How-to-look-up-a-value-to-see-if-it-exists-in-a/m-p/779981#M20159 <P>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.</P> <P>Are you able to send any of this here? If not, I'd suggest opening a ticket with Technical Support by email at <A href="mailto:support@sas.com" target="_blank">support@sas.com</A>.</P> <P>&nbsp;</P> <P>Thanks,<BR />Audrey</P> Fri, 12 Nov 2021 14:39:01 GMT audrey 2021-11-12T14:39:01Z https://communities.sas.com/t5/SAS-Data-Management/Dataflux-2-8-How-to-look-up-a-value-to-see-if-it-exists-in-a/m-p/779960#M20158 <P>I have created lists that contain addresses for each member in our database.&nbsp; If a new record comes in, I want to search on that list to see if the address currently exists or is new.&nbsp; A member could have multiple addresses in their list ie Mailing addr, home addr etc.&nbsp;</P> <P>Im assuming it needs to be in an expression node but just not sure how to do it.&nbsp; 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.&nbsp;</P> <P>&nbsp;</P> <P>TIA</P> Fri, 12 Nov 2021 12:28:06 GMT https://communities.sas.com/t5/SAS-Data-Management/Dataflux-2-8-How-to-look-up-a-value-to-see-if-it-exists-in-a/m-p/779960#M20158 beamer108 2021-11-12T12:28:06Z https://communities.sas.com/t5/SAS-Data-Management/Dataflux-2-8-How-to-look-up-a-value-to-see-if-it-exists-in-a/m-p/779981#M20159 <P>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.</P> <P>Are you able to send any of this here? If not, I'd suggest opening a ticket with Technical Support by email at <A href="mailto:support@sas.com" target="_blank">support@sas.com</A>.</P> <P>&nbsp;</P> <P>Thanks,<BR />Audrey</P> Fri, 12 Nov 2021 14:39:01 GMT https://communities.sas.com/t5/SAS-Data-Management/Dataflux-2-8-How-to-look-up-a-value-to-see-if-it-exists-in-a/m-p/779981#M20159 audrey 2021-11-12T14:39:01Z