Hi Alteryx engineer,
I have some data from .xls file, it has single quote at the beginning, but when alteryx read the data, it automatically remove this single quote
Is there any way i can keep this single quote?
Thanks
I think possibly because that's how Excel stores numbers as text, Alteryx will read that cell in as a text and disregard the apostrophe. You could manually add an single quote apostrophe to this field if required? I can't really see a use case to keep it though.
Could you provide the file in question (with sensitive data removed)?
The thing is I need to check if the spostrophe is existing, so I can't add it manually. The client require to check it is there.PFA for the data
Hi,
Anyone figured it out?
Any workaround to use it?
Thanks
I don't believe this is possible using the standard input data tool.