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

Dynamic removing data

k3pineapple
8 - Asteroid

Hi all,

 

I am trying to remove the specific data in the each cell. not sure which function i should use here. thx

 

Input

CompanyUserProductSector Name
ABCAmyAppleSector 1
ABCAmyAppleSector 2
ABCCindyBananaSector 3
ABCDaveCherrySector 4
DEFEasonAppleSector 1
DEFFrankBananaSector 2

 

Output

CompanyUserProductSector Name
ABCAmyApple1
ABCAmyApple2
ABCCindyBanana3
ABCDaveCherry4
DEFEasonApple1
DEFFrankBanana2

 

Many thx

2 REPLIES 2
sparksun
11 - Bolide

Use the following formula:

Replace([Sector Name],"Sector ","")

 

 

k3pineapple
8 - Asteroid

appreciated

Labels
Top Solution Authors