Hi, I created a workflow using the sample data that comes preinstalled with Alteryx. "TutorialData.yxdb" is the sample database which contains a field named "Gender" however the format looks strange (see image of table).
Why is the data formatted that way in the Gender column?
Gender
*~~//*~~//female
*~~//*~~//male
Solved! Go to Solution.
Hi @Coder ,
I have no idea, but you can remove it by placing a regex tool in the line after the first tool and select the Gender field:
Copy and paste the characters you want to remove into the yellow section in the regex tool.
That will then remove them for you.
M.
Thanks M! I will use the regex tool to remove it.