Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Delimiters (spaces, /) in string elements changed to underscore while using crosstab

arx
6 - Meteoroid

I was trying to get unique elements from a mapping dataset using crosstab so that I can use it as a UI option.  Though, I was able to get the UI running, it changed the spaces and other punctuation to underscore.  My requirement is that when the user selects the elements from the list box, these elements can be used for subsetting from the initial dataset for further processing with an R script.  As these elements change their punctuation, it becomes difficult to match it exactly.  How do I correct.  I am attaching the screenshot of the mapping data.

Initialproducts.PNG

 

If we look at the data after the crosstab

 

Aftercrosstab.PNG

 

 

Below is the workflow

 

 

workflowforCommunity2.PNG

 

  

I am not sure where exactly it got changed.  I would appreciate any reply.

1 REPLY 1
arx
6 - Meteoroid

I was able to solve it using this workflow

 

 

SolvedItems.PNG

 

The UI part now looks like

 

Solved2.PNG

Labels
Top Solution Authors