Hi Alteryx Team, Is there a tool/formula I can use to split my data in such a way there are 2 results in the workflow - NAMEAMOUNTMTO5CTO9KTO1BTO56MTO21CTO99 Result to further work on should be - NAMEAMOUNTMTO5MTO21CTO9CTO99 and, NAMEAMOUNTKTO1BTO56 Please help.

Tool/Formula Workflow Help

Hi Alteryx Team,

Is there a tool/formula I can use to split my data in such a way there are 2 results in the workflow -

NAME	AMOUNT
MTO	5
CTO	9
KTO	1
BTO	56
MTO	21
CTO	99

Result to further work on should be -

NAME	AMOUNT
MTO	5
MTO	21
CTO	9
CTO	99

and,

NAME	AMOUNT
KTO	1
BTO	56

Please help.

Workflow

Help

Accepted answers

Jonathan-Sherman

Hi,

Does this achieve what you're looking for in that case? Effectively, checking how many of each name exist and filtering for where the count > 1.

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

Regards,

Jonathan

20191108 - FilterHelpyxmd.yxmd

All comments

NickSm

Hey @henrygeorge

Can do this pretty easily with a Filter tool. Example attached

If you have more than just those two buckets to create, you could use the same process to add additional filters.

name_filter.yxmd

Jonathan-Sherman

Hi,

I've filtered just for where Name = 'MTO' or 'CTO'

Formula in the filter [NAME] IN ('CTO', 'MTO')

Table 1:

Table 2:

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

Regards,

Jonathan

20191108 - FilterHelpyxmd.yxmd

henrygeorge

@Jonathan-Sherman @NickSm The Filter Tool can't be used here. As I don't want to filter it based on MTO and CTO. They should be automatic - in such a way that if KTO/MTO/BTO is matched with another KTO/MTO/BTO then, they should shown separately and the other single names should be shown separately. Basically if the names match push to separate result to work on; if names don't match push those names to another result to work on. Please advice how I can achieve this.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703