Sort Unique ID as given and not based on ascending or descending

Question

Hi All,

Please I'm trying to re-order and/or sort the ID such that the data in the Input Tool can match the data in the Text Input Tool.

Data in Input Tool

Record  Market Participant

1                Hedge Fund

2                Long & Short Strategy

3                High Speed Trading

4                Private Equity

5                Leveraged buyout

6                Management buyout

Note: The record is not a data column but rather Alteryx's default row numbering.

Data in Text Input Tool (Intended Output)

Product ID  Market Participant

1.                  Hedge Fund

20                Long & Short Strategy

21                High Speed Trading

2.                 Private Equity

78                Leveraged buyout

79                Management buyout

Data Explanation

Product ID 20 and 21 are categories of Product ID 1.

Note: 1. a string and not a numeric number 1. A string was used to number the Market participants including Hedge Fund and Private Equity but use an actual unique Product ID to number their sub-categories.

Thank you for all your help.

Kind regards.

Taiwo Adegoke.

inumidun2009 · Answer

Thanks again, Angelos.

I tried your workflow but my data output was missing some ordering.

Apologies I messed up with the dynamics in my data.

I found out that my data has similar numbering in the Text Input Tool (Intended Output Data) as seen below.

Please see below;

Data in Input Tool

Record     Market Participant

1                Private Equity

2                Leveraged buyout

3                Management buyout

4                Small Management

5                Hedge Funds

6                Long & Short Strategy

7                High Speed Trading

8                Small Management

Note: The record is not a data column but rather Alteryx's default row numbering.

Data in Text Input Tool (Intended Output)

Product ID  Market Participant

1.                Private Equity

1                Leveraged buyout

2                Management buyout

3                Small Management

2.                Hedge Funds

7                Long & Short Strategy

8                High Speed Trading

9                Small Management

Data Explanation

Product ID 1,2 and 3 are categories of string 1.

Product ID 7,8 and 9 are categories of string 2.

Thanks again for your help.

Kind regards.

Taiwo Adegoke.

AngelosPachis · Answer

Hi @inumidun2009 ,

Here is the updated workflow. Please let me know if that worked for you, and if not kindly share the issue so we can solve this one.

Cheers,

Angelos

example_v2.yxmd

inumidun2009 · Answer

Hey Angelos,

Apologies for the delay in response. Thanks for your timely response.

I used your workflow snapshot. But my ordering is a bit off for certain rows.

I tried downloading the attachment but it does not show the updated workflow with the Record ID Tool. Please help to attach your updated workflow.

Thanks a lot for your help.