If Statement Question for a Newbie

dobusch

First off thanks for your collective help, I've been using Alteryx for a few months and wouldn't have any idea what to do without the help of this community! 

Question: 

If I have the following table, what would be your suggestion for an IF statement that will give me the results in the 3rd column-

Business Number	Business Type	Businesses w/ only a single type
1	House	-
1	Apartment	-
2	House	2
3	Apartment	3
4	Apartment	4
4	Apartment	4

I only want businesses that are associated with a single business type. (they can multiple of the same type i.e. business number 4) 

Hope this is clear..

Jonathan-Sherman

Hi @dobusch,

I would probabbly take the approach of summarising to find the number of unique business type per business number (count distinct). Join this back on to your original table and use a formula (IF function) to create the new column with the values desired. Finally a select tool to remove the count distinct column we joined. You could use a filter tool after the select to filter out records with a hyphen and keep only those where the business number has been brought through.

The workflow would look like:
 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200324 - SummariseAndIFStatement.yxmd