In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Remove duplicate characters on string

aurzuao
6 - Meteoroid

Hi there, is it possible to remove duplicate characters on string ? 

 

Example of the desire output:

 

HELLO WORLD -> HELO WRD

DIRECTOR -> DIRECTO

9999 -> 9

??? -> ?

5 REPLIES 5
binuacs
21 - Polaris

@aurzuao One way of doing this

image.png

MilindG
12 - Quasar
aurzuao
6 - Meteoroid

Thanks ! This works

flying008
15 - Aurora

Hi, @aurzuao 

 

Another way , just like @binuacs .

 

录制_2023_08_02_08_33_06_71.gif

PhilipMannering
16 - Nebula
16 - Nebula

@binuacs Why would you not just using the Unique Tool, where you've used the Tile and Filter Tool?

Labels
Top Solution Authors