Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎02-25-2021 09:24 AM

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? 

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora
‎02-25-2021 09:30 AM

@Marta12,

 

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

messi007_0-1614274191843.png

 

Attached the workflow,

 

Regards,

 

DynamicRename_20210225.yxmd
Reply
PhilipMannering
16 - Nebula
16 - Nebula
‎02-25-2021 09:30 AM

Hi @Marta12 ,

 

For this, you could use the dynamic rename.

 

PhilipMannering_0-1614274247274.png

 

rename ro remove underscores.yxmd
Reply
Marta12
7 - Meteor
‎02-25-2021 09:44 AM

Thank you @PhilipMannering  and @messi007. 

This is what I was looking for.

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

Reply
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels