Alteryx read data with single quote missing

[187]

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

[PhilipMannering]

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)?

[187]

@PhilipMannering 

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

[ravi061]

Hi,

Anyone figured it out?

Any workaround to use it?

Thanks

[apathetichell]

I don't believe this is possible using the standard input data tool.