Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Sorting Data in a specific order by Find Replace and Text Input

cstafford
8 - Asteroid

I have created a few workflows and create a rank specific sort by using the Find Replace tool and Text Input which has my specific sort information. However, on a new workflow this process is not working as the Find Replace tool is not recognizing the text input headers, so I cannot select the appropriate header in the Find Value section.My assumption this has to do with the crosstab tool prior to my sort? Any solutions or workaround?

 

 

FindReplace_TextInput_working.PNGFindReplace_TextInput_NotWorking.PNG

 

2 REPLIES 2
Kenda
16 - Nebula
16 - Nebula

Hey @cstafford 

 

Make sure that the field you're using in the Find Replace tool is a string.

Thableaus
17 - Castor
17 - Castor

Hey @cstafford 

 

Adding knowledge to great observation from @Kenda, Codes and Order Numbers are usually numbers and if they are passed in a Text Input, they are automatically recognized as an Int Type and reduced to the most optimal size.

So a Select Tool is very welcome when using the Text Input, ok?

 

Cheers,  

Labels