Filter Values in a Group

[Sarath27]

Hi All,

I badly need your help on this where I am stuck for days. I have 287291 records of data where I grouped by them "FULL NAME" giving Cluster ID. Now my next goal is to find the following

1. If any record in a cluster has "5 CANADA SQUARE" in its address line, then other records have same "Address" - Then "It should be labelled as "1"

2.If any record in a cluster has "5 CANADA SQUARE" in its address line, then other records have 2 or more different "Address" - Then "It should be labelled as "2".

3.If Cluster doesn't have ""5 CANADA SQUARE" in its address line", then it should be labelled as "3".

I know this is bit complicated, please help me out with this that'd be very much helpful for me.

[Sarath27]

Hi Luke, Thanks much, it works well!

As you can see below, Cluster 2 has 4 Address line, Apart from 5 CANADA SQUARE, rest of them are same, so these needs to be labelled separately just to distinguish between 2.

Label 1 & 3 works fine, just distinguish this scenario from 2 and help me to label them as 4.

If you add the below data in Sample data of that workflow, you could get the above scenario. This would be the last step, rest all too good!  Extremely helpful. Thanks much for your prompt response Luke!

[Sarath27]

Hi Luke,

Here is the New Sample data, please help me with this!  The full purpose is served if I figure out this last step.

[Luke_C]

Hi @Sarath27 

I don't see any new data posted. I'd urge you to take a stab at it yourself and let us know if you face a specific issue. You have a good starting point.