Matching ID's

[gduffy]

I am trying to see if ID's in column Party/Registry ID are in the Customer Party Number - Bill To. If it shows up in the Customer Party Number Column can you assist me with adding a third column with Accounted for or Not included.

[KGT · Accepted solution]

So, checking whether any value from the left column is in the right column?

Are they exact matches, or contains matches?

If exact, separate the 2 columns into 2 different streams and then use a join to find all the matches. Formula and Union to create extra field, bring it all back to a complete list etc.

[binuacs · Accepted solution]

@gduffy one way of doing this 

[gduffy · Accepted solution]

They should have some matching values but when I join the stream it populates an error even after assigning the same "type" match. 

[KGT]

You are changing the type in the Join. It needs to be changed before the join. 

Also, if these are ID's then they should be strings not numbers.

[gduffy]

Thank you!

[gduffy]

thank you!