Alteryx Designer Desktop Discussions

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

Removing certain symbols in the cells in multiple columns

kv-defy
8 - Asteroid
 ITHRAccountsMarketingCS
Cost 1585018281-9991-
Cost 2-102----3912
Cost 3-289-9382-291828581

 

I have a lot of columns and rows that I wished to convert the dash to "-" that matches the cell value and changes to 0. Is there any ways to do it the faster way? I have tried using filters and formula but it is simply too tedious as there are a lot of columns that I have to deal with the data. 

 

 ITHRAccountsMarketingCS
Cost 1585018281-99910
Cost 2-102000-3912
Cost 30289-9382-291828581
2 REPLIES 2
Qiu
20 - Arcturus
20 - Arcturus

@kv-defy 

We can use the Multi-Field Formula tool for multiple column replacement.

0622-kv-defy.PNG

binuacs
20 - Arcturus

@kv-defy another way of doing this with the Transpose and Cross tab tool. @Qiu nice one tool solution :)

binuacs_0-1655880234076.png

 

 

Labels