Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to remove underscore from all the columns

gagandeep_dhall
8 - Asteroid

Hi Everyone,

 

I have a file which will have a column added to it everytime a file comes for a month.

 

But, when I use Cross-tab to group them and create that column, it adds "_" to the column Name, as below:

 

Process NameDec_2020Jan_2021
Process 1abcbcd
Process 2gbdgsh

 

I know I can use "Dynamic Rename" tool, but it doesnot works on the new column that gets added every month.

2 REPLIES 2
DavidP
17 - Castor
17 - Castor

I would use a technique like this to replace the underscores after the Crosstab.

 

DavidP_0-1610471942591.png

 

pedrodrfaria
13 - Pulsar

Hi @gagandeep_dhall 

 

Just for context and educational purposes. The dynamic rename should work with new columns. If you check the Dynamic or Unknown Fields option, it will update new incoming fields that did not exist on the previous month.

pedrodrfaria_0-1610474007637.png

 

 

@DavidP 's solution also is a good way to get around it.

 

Pedro.

Labels