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.
If we look at the data after the crosstab
Below is the workflow
I am not sure where exactly it got changed. I would appreciate any reply.
Solved! Go to Solution.
I was able to solve it using this workflow
The UI part now looks like