Start Free Trial

Alteryx Designer Desktop Discussions

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

Cross tab Tool is changing headers name "-" or "/" replace with "_"

Marta12
7 - Meteor

Hi, 

I have issue when applying Cross Tab Tool. 

Tool is changing headers name "-" or "/" replace with "_". And I need them to stay in column format.

 

Visualization

 Input data:

Marta12_0-1614273606131.png

Results after cross tab

Marta12_1-1614273700922.png

And I really need to headers to be in format from input column 6/30/1949 ( MM/dd/yyyy).

 

Can anyone know how to solve this issue? 

 

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@Marta12,

 

Please see below, you can do that with a Dynamic Rename

messi007_0-1614274191843.png

 

Attached the workflow,

 

Regards,

 

PhilipMannering
16 - Nebula
16 - Nebula

Hi @Marta12 ,

 

For this, you could use the dynamic rename.

 

PhilipMannering_0-1614274247274.png

 

Marta12
7 - Meteor

Thank you @PhilipMannering  and @messi007

This is what I was looking for.

I'm still learning Alteryx I really appreciate your help. 

Labels
Top Solution Authors