community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Cross Tab turns - into _

Asteroid

I used Find Replace to convert Tile Tool Tile_Num 1 to 13 into -1 to -13.  I then used the Cross Tab to put the data into columns.  However, the Cross Tab tool takes the '-1' and makes it '_1'.

I need to convert the _1, _2 back into -1 and -2.

 

In the process of writing this question, I answered it, so I thought I'd continue and share.

I used the Dynamic Rename tool to remove the prefix '_' and then used another one to add the prefix '-'.

 

So I guess I'll leave off with: Why does the Cross Tab tool convert the '-' into '_'?

 

Highlighted
Alteryx
Alteryx

The CrossTab tool has what I call field name protection in it.

 

It won't allow characters that databases and other systems won't like. Like - or & or even spaces as some systems don't like that.

 

Afraid that's my interpretation though, so not sure on an official line (all be it I now work for Alteryx, but was a customer of 8 years prior)

 

Nebula

Hi @Number4 

 

I agree that it's a pain, but Alteryx does so many other things really well. 

 

As an aside, you should be able to get by with just one Dynamic Rename with the following formula

 

Replace([_CurrentField_],"_","-") 

 

Dan 

Asteroid
Replace([Current Field],"_","-") 

This was my first approach, but the cross tab gives me 13 columns....currently

Labels