How to force Alteryx to input the column as text (sharepoint tool)

[kowan]

Hi:) 

I have excel which I want to use loaded via SharePoint tool. The thing is that Alteryx treats it as INT not Text, and cut the leading 0s. 

Here is the example of the input

in excel the column is set to text of course, and what Alteryx is doing: 

of course converting to string in the next steps do nothing as it was removed in 1st stage.. Note that number of 0s can vary, and also not all have 0s.. 

Thank you

Regards

Kornelia

[kowan]

HI thanks, this is also possible solution as of now we ended with dummy row