Hi,
some of my columns are already _ and some have space. I want to keep the columns with space as space and underscores as undersscores.
It looks like the crosstab is making my data go from space to _.
Ie in my workflow Insured Deposits is going into "Insured_Deposits".
Normally I would do the solution mentioned here - https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Underscores-After-Cross-Tab/td... . Dynamic Rename on the column you want to put back the space to.
However my columns are not static and change often + if I apply a rename or replace to ALL columns with "_" i dont want to take the "_" out of my "Right_Bank" column.
Please help.
Solved! Go to Solution.
@wonka1234 You can still use the Formula function in a Dynamic Rename tool and deselect "Right_Bank" and keep "Dynamic or Unknown Fields" selected. That way, any field that comes into the workflow will always be selected to be affected by this expression: replace([_CurrentField_], '_', ' ')
@wonka1234 One way of doing this
@Prometheus i cant just deselect Right_Bank. my columns arent static. my columns could be Right_Thing, Right_OtherThing.. etc
@binuacs @Christina_H tried both your solutions , not exactly what I wanted. check updated workflow
@Christina_H thanks. So Close. That concat_name column is missing though when you do your crosstab.
It's not clear what you want - my output matches your crosstab with the columns in a different order. Is this what you're after?
If so, you just need to group by Concat_Name in the crosstab tool
@wonka1234 attached updated wrkflow