Maintaining Special Characters in Column Header via Transpose

Hi All,

I'm having issues with the Cross Tab function removing special characters from the cells that I want to use as my column headers downstream.

Is there any way to prevent that tool from removing special characters when it creates the new column names? I was thinking that maybe there were some sort of dummy characters that I could put before/after to act as a buffer, but no success as of yet.

Cheers,

Travis

Transformation

Accepted answers

MarqueeCrew

@TravisJWhite,

With that edit, this makes more sense to me. What I would suggest is that you create a set of replacements for what will become the header data.

BAD, GOOD

Field_1, Field 1

My_Field, My+Field

You can use an expression like Regex_Replace([Field],"[^a-zA-Z0-9]",'_') to emulate the crosstab.

This table of fieldnames can be used in a DYNAMIC RENAME tool that will exchange any BAD field names for the GOOD ones.

Cheers,

Mark

All comments

MarqueeCrew

I've seen that with cross tab, but not with transpose. Can you provide some sample data to help us help you?

Cheers,

Mark

TravisJWhite

Hey There,

Sorry - I included the incorrect tool name - it is, in fact, Cross Tab. Edited with correct tool name.

Any solutions for Cross Tab?

Ex: % CY HHs Families with Related Children < 18 Yrs --> ___CY_HHs_Families_with_Related_Children___18_Yrs_

MarqueeCrew

@TravisJWhite,

With that edit, this makes more sense to me. What I would suggest is that you create a set of replacements for what will become the header data.

BAD, GOOD

Field_1, Field 1

My_Field, My+Field

You can use an expression like Regex_Replace([Field],"[^a-zA-Z0-9]",'_') to emulate the crosstab.

This table of fieldnames can be used in a DYNAMIC RENAME tool that will exchange any BAD field names for the GOOD ones.

Cheers,

Mark

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703