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

[cstafford]

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?

[Kenda · Accepted solution]

Hey @cstafford 

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

[Thableaus · Accepted solution]

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,