Filter Values in a Group

A bit tough with only screenshots of the data, but here's what I'd suggest you do:

Filter on ADDR_LINE1 = 5 CANADA SQUARE
Summarize the cluster IDs from the T anchor (this will be your clusters with 5 canada as an address)
Join those IDs back to your main data set. Anything that falls out will be your '3's
From the J tool, do another summarize and count the distinct addr_line1 values. Anything with 1 distinct address will be your clusters with only 5 canada square, anything with more than 1 will have multiple addresses.

Give that a go and see how you make out. If you have any issues, some sample data and the workflow you tried will be helpful.

Try this. This is what I described above.

Sample_Workflow.yxmd

All comments

As you can see below this Cluster_ID = 105, has "5 CANADA SQUARE" in ADDR_LINE1, but other address in the same cluster has two different "Address, so in this case it should be labelled as "2".

A bit tough with only screenshots of the data, but here's what I'd suggest you do:

Filter on ADDR_LINE1 = 5 CANADA SQUARE
Summarize the cluster IDs from the T anchor (this will be your clusters with 5 canada as an address)
Join those IDs back to your main data set. Anything that falls out will be your '3's
From the J tool, do another summarize and count the distinct addr_line1 values. Anything with 1 distinct address will be your clusters with only 5 canada square, anything with more than 1 will have multiple addresses.

Give that a go and see how you make out. If you have any issues, some sample data and the workflow you tried will be helpful.

Hi Luke,

Thanks much for your prompt response. I tried, but it didn't work. I have attached sample data for each scenarios(1,2,3), please kindly create a workflow from this and guide me the way to achieve my desired output.

Please share the workflow you attempted to create and I'll be happy to look and see where you might have gone astray.

Luke,

Please find the workflow, do the needful. Awaiting for your positive response in it. Label 3 I have completed! Only Label 1 and 2 yet to be figured out

I don't have access to your input.. please export the workflow as a yxzp so the data is included. Options>Export Workflow

Luke, Here you go!

Try this. This is what I described above.

Sample_Workflow.yxmd

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!

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.