Hello,
I have a data input which is and excel table. When I loaded to Alteryx, my strings in the output get changed and now start with a " ' ". The other fields (double and date are fine) How can I fix this? I tried cleaning leading spaces when I first load the file but it didn't work.
Example of my issue below:
Input:
Output:
Column 1 | Column 2 | Column 3 | Column 4 |
'A | 1 | 1/1/2001 | 'F |
'B | 2 | 1/2/2002 | 'G |
Thanks
Solved! Go to Solution.
Can you share the file you are using as input? to try running from my end
This looks interesting. As per below article, it explains that, Alteryx by default adds ' symbol before the string (text) fields. This is only for xls files.
Please have a look. Using VBA was suggested in the below article.