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

[inumidun2009]

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.

[AngelosPachis]

Hi @inumidun2009

I have created a workflow that does what you are looking for in the given dataset.

Do you mind giving this a try to your data and see if it works?

Thanks

Angelos

[inumidun2009]

Hello Angelos,

This is amazing. Thank you for timely response. I was observing my output.

It worked accurately for my data.

But I spotted another dynamics in my data.

Here is it below:

Data in Input Tool

Record     Market Participant

1                Private Equity

2                Leveraged buyout

3                Management buyout

4                Hedge Funds

5                Long & Short Strategy

6                High Speed Trading

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

Please how do I go about sorting the data in the input tool to have this order of Product ID in the Text Input tool?

Though, I am worried Altery'x order of sorting would kick in here.

Thanks again.

[AngelosPachis]

Hi @inumidun2009 ,

Thank you for the updated dataset. I was anticipating that something would go slightly off, so I've made a couple of tweaks to the workflow to force the order that you want your data to appear.

The extra tool was a record ID tool right after your text input tool that you will use to arrange the different records in the correct order, and then remove it with the select tool at the end.

Hope that helps,

Angelos

[inumidun2009]

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.

[AngelosPachis]

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

[inumidun2009]

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.