- Underscores After - Cross Tab

Question

Hi All,

I have searched the community already and there where more solutions but looking for a solution on my specific requirement

I'm doing the crosstab tool function within a macro and then outputting the data from my macro to overwrite the input file.

The input columns looks like these..

Customer Name - Contact

Customer Name Contact: Contact-Address

Customer - Age

But After crosstab

Customer_Name_Contact

Custome_Name_Contact_Contact_Address.

Customer_Age

I'm looking for a solution where i don't want to rename the columns using the select tool since i have a huge list of Columns rather a dynamic way so that the name matches exactly the same as Input Data Columns.

Thanks

binu_acs · Answer

@suby one way of dong this by only taking the column names then using dynamic rename tool replace the cross tab columns, this way you can keep the original column names

DynamicRename_04_07.yxmd

DataNath · Answer

How does this look @suby? Instead of hard-coding replacements, this may be a little more dynamic. The underscores basically come from Alteryx replacing 'special characters' like spaces and punctuation with _ when Cross-tabbing. One of the options of the Dynamic rename tool is that we can provide a header to look for and what to replace it with. Therefore, this Formula tool off-shoot basically replaces anything that isn't a word in the original header with _ and so should create a copy of what the Crosstab tool will output, meaning we can just use that as a reference to find and replace it with the original header:

EDIT: Forgot to mention. This also means that if there does happen to be underscores in your desired headers, these 'innocent' underscores won't be removed.

Dynamic rename from rows.yxmd

IraWatt · Answer

I had a try with Customer Name Contact: Contact-Address and it didnt remove the semicolon and a hyphen. You could untick that column from the top if your having issues. Or we could make the formula more complex.

Workflow.yxmd