topic Sort Unique ID as given and not based on ascending or descending in Alteryx Designer Desktop Discussions

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

inumidun2009 — Sat, 30 Jan 2021 20:22:07 GMT

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.

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

AngelosPachis — Sat, 30 Jan 2021 20:32:17 GMT

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

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

inumidun2009 — Sat, 30 Jan 2021 21:47:07 GMT

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.

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

AngelosPachis — Sat, 30 Jan 2021 22:34:00 GMT

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

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

inumidun2009 — Sun, 31 Jan 2021 03:01:17 GMT

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.

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

AngelosPachis — Sun, 31 Jan 2021 08:59:42 GMT

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

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

inumidun2009 — Mon, 01 Feb 2021 04:50:37 GMT

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.