Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account 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
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