Are values within a group equal

[Masond3]

Hi All, 

Hoping to pick you brains on best approach 

Aim : For given ID I need to check if the values match and if its matches then then flag them as "Yes" if not equal then "No".

Currently : I have two data inputs, in both Inputs i have two columns (Id & ,Name), I have union'd the two data sets together

Input A

ID	Name
11111	Masond3
22222	Apple Inc

Input B

ID	Name
11111	Masond30
22222	Apple Inc

Union Output 

ID	Name
11111	Masond3
11111	Masond30
22222	Apple Inc
22222	Apple Inc

Expected outcome 

ID	Name	Name Match
11111	Masond3
11111	Masond30	No
22222	Apple Inc	Yes
22222	Apple Inc

[Christina_H]

How about a distinct count of names?

[Masond3]

@Christina_H i thought about that option, however i am thinking of scalability.

At the moment we have two inputs(this potentially going to expand to 10). It is possible that an ID, wont be in the other 9 sources, so doing a distinct count, i dont think would work ? ( could be mistaken though)

[Christina_H]

What do you want to happen if the ID is missing from some of the sources?

In this version, if the ID isn't in one of the sources it would still be labelled as True (there's exactly one variation of name for that ID).

[Masond3]

@Christina_H  i think in this scenario, i cant evaluate it against another record, thereforei think the "Name match" would remain blank

The overall goal, is to flag records where this mis-matches, ( therefore i think there would need to be a minimum of two in a group ie iD) 

[Christina_H]

OK, how about adding a regular count as well as the distinct count?  Name Match can then be reset to null if count=1

[Rana_Kareem]

Hi @Masond3 ..

You can try this method.

 

Hope it helpful..

[Masond3]

@Christina_H  I think you are along the right lines. so the way i see the "Name match" in this scenario is that its flagging a group, is there a way on top of this to call out exactly row would be mis-matched within that group,( if i indicated what input trumps input, ie input A always supersedes input B. so in the scenario of masond3 vs Masond30, Masond30 would be the one which is incorrect, as it should align to masond3

[Christina_H]

So something like this?

[Masond3]

@Christina_H 100% thats the exact outcome i would want !can you share your wf?