Same-Same-Different

Question

Hi All,

I have recently moved to Alteryx and it has been an interesting ride so far. Very positive and, at times, frustrating.

I am trying to extract records from a report where I want to find entries classified as same-same-different

For example (same accounting entry document but different project)

Source data

Document Project

ABC1234A1ABC1234A2ABC1234A2ABC1234A3DEX2456A4DEX2457A5DEX2458A6DEX2458A6DEX2458A6DEX2458A9

Results

Document Project

ABC1234A1ABC1234A3DEX2458A6DEX2458A9

Any ideas or any links to tips would be great

Thank you

Qiu · Accepted Answer

@sdemichelis 
It will be better if you could elaborate the meaning of "same-same-different".
I have assume then made something like below.

TSP · Accepted Answer

@sdemichelis,interested to know whether you think

ABC1234A2

should be excluded from your results?

If you want it included as an exception (i.e Project A2 has also had Document ABC1234 posted to it), then take the result of @Qiu 's centre join, but add a Unique tool rather than a summarise tool. Select the Document field, project field, (and any others you may think are relevant).

The U ("unique") output of this tool would be my answer.

sdemichelis · Accepted Answer

@TSPthank you. Both solutions work for what I am looking for. One is more restrictive than the other and both brilliant. Many thanks!

TSP · Accepted Answer

To make it even leaner, you could employ the CReW Macro set, and use the Only Unique tool:

TSP · Accepted Answer

This would give you all duplicated Document ID's, which you could summarise however you wish.

They're available here:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740