Sorting Order

JDong

Hi Team,

Sort Column

ANA

ARAX

Armani

Basics

C and A

Capital

Peak

Pentagon

Porvai

QUEST

Quantum

RFE

REALISTIC

Savigny

SIGNAL

The Capitol

TLD Immov

TPGIT

Tisha

Union Jack

DC Values

Wealthny

Westen Part

WeWoke

alstrivia

pwr

I want to sort all the records shown in ascending order. Irrespective of it beign small or capital. Any idea here please since the sort tool options are not helping.

Thanks

Datasets

Developer

Developer Tools

Accepted answers

Qiu

@JDong

I think his continent is night time now😁

Make a minor change based on @AngelosPachis work.

example-R1.yxmd

All comments

AngelosPachis

Hi @JDong ,

What you can do is use a formula tool to create a new field which contains the lowercase version of that initial column.

Then you can use a sort tool to to sort based on that new field in an ascending order, and then drop it with a select tool

Hope that helps,

Angelos

example.yxmd

JDong

Thanks @AngelosPachis this is great...is there a way to make only first letter in capitals and rest in small ?

echuong1

Another option is to use the data cleansing! You can modify to title case at the bottom.

New Workflow1.yxmd

danilang

Hi @JDong

Check the "Use Dictionary Order" option in the sort Tool

Results are sorted irrespective of letter case

Dan

DictionarySortOrder.yxmd

JDong

Thanks to all of you !

The solution accepted works for the use case. The dictionary order did not work on my dataset.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703