Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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
21 - Polaris
21 - Polaris

@kv-defy 

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

0622-kv-defy.PNG

binuacs
21 - Polaris

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

binuacs_0-1655880234076.png

 

 

Labels
Top Solution Authors