topic Re: exclude records from DIAGRAM A that exist in DIAGRAM B in SAS Customer Intelligence

exclude records from DIAGRAM A that exist in DIAGRAM B

keiwo — Wed, 16 Aug 2017 14:50:31 GMT

Greetings SASCI colleagues,

*** please refer to attachment for details ***

Diagram A ( Blue )

Diagram B ( Red )

Question: How do I go about excluding records from DIAGRAM A that exist in DIAGRAM B

Thanks,

Keith

Re: exclude records from DIAGRAM A that exist in DIAGRAM B

pcapazzi — Wed, 16 Aug 2017 19:45:42 GMT

The end result of Diagram B should be a Cell that you name appropriately so you can easily identify it and select the option to make it Linkable. Save Diagram B.

In the Diagram A the end node should be a Cell. Then create a Link Node and select the cell from Digram B as the source. Then create a Prioritize node point Diagram B's cell to it first and then point Diagram A's cell to it next. Open the Priority node and check that Diagram B is in fact at the top of the priority list (matches will get pulled out) and that Diagram A's selection is second (post-suppression). Then save and execute.

That's one way to go about it.

Re: exclude records from DIAGRAM A that exist in DIAGRAM B

keiwo — Thu, 17 Aug 2017 13:33:15 GMT

Thanks pcapazzi,

what if both Diagrams A & B are within the same campaign. How would I then go about to excluding records from DIAGRAM A that exist in DIAGRAM B

Thanks,

Keith

Re: exclude records from DIAGRAM A that exist in DIAGRAM B

keiwo — Thu, 17 Aug 2017 13:54:08 GMT

Hi Pcapazzi,

I applied your suggestion and it worked even when both DIAGRAM A & DIAGRAM B are within the same campaign diagram.

Much Appreciated 🙂

Re: exclude records from DIAGRAM A that exist in DIAGRAM B

pcapazzi — Thu, 17 Aug 2017 13:55:51 GMT

Happy to help!