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
20 - Arcturus

@aurzuao One way of doing this

image.png

MilindG
12 - Quasar
aurzuao
6 - Meteoroid

Thanks ! This works

flying008
14 - Magnetar

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