Cross Tab is Replacing space between column names with underscores
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am having around 150 rows that needs to be converted into Column Names, whenever I use Crosstab tool it auto replaces space between the column Names with Underscores is there any way to avoid this, My Column Names are dynamic and keep changing every time.
Is there any alternative way to do this rather than using Select tool to renames these column names just to remove Underscore in the headers
Solved! Go to Solution.
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes ! You can use the dynamic rename tool in the developer tool pallet.
Select all of the columns (including dynamic or Unknown Fields) and select Rename mode: Formula
Then use the formula below:
replace([_CurrentField_],"_"," ")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@gautiergodard Thank you heads up , does this apply for Headers are data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@saiirangam Correct, this will apply to the column headers in your data set.
Please dont forget to accept this post as a solution if it answered your question!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you it worked