Why doesn't the column name persist '%' ?

[Gelly]

Hello all, 

It might be a super simple and stupid question but I do not understand why is this happening. 

I have added a sample workflow with a small subset of proxy data. I want to add '%' to the column name dynamically but for some reason, if I use a formula tool and then use cross tab to convert the rows to column name then it becomes 'APR__' instead of 'APR%' . 

Way-2 works if I used a select tool to change the column name but I want it to be dynamic. 

I appreciate any help and suggestion. 

[alexnajm]

It is just the nature of the Crosstab tool, nothing you are doing wrong. It replaces any spaces, punctuation, or symbols with underscores 

most people will either use a select tool afterwards, or a dynamic rename to reverted back to what you would want it to be called!

[DavidP · Accepted solution]

Hi @Gelly 

The Crosstab tool replaces all non alphanumeric characters with underscores, but there's a workaround as shown below

[Gelly]

I see. No wonder it kept removing any no alphanumeric value. 

I get it now. Thank you! 

[atcodedog05]

Hi @Gelly 

You can update your Way-1 like below

Hope this helps : )

[Gelly]

I understand it now. I will use dynamic rename. Thank you!