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

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.

Workflow

Optimization

Accepted answers

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

crostab rename.png

All comments

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!

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

crostab rename.png

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

I get it now. Thank you!

You can update your Way-1 like below

Screenshot 2024-10-30 200841.png

Hope this helps : )

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

Quick Links

Unanswered
Community Events
Groups

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703