String Value but Alteryx adding a decimal point

Question

I have data that looks like:

Contract ID1234512AB03TBD

Select tool shows that this column is define as string, however when I run the workflow and have the output I see that it has changed to:

Contract ID12345.012AB03TBD

How do I stop alteryx from adding that decimal point..

apathetichell · Answer

How are these values formatted in excel? What version of Alteryx are you running? Is amp on? sometimes Alteryx and excel try to be too smart.

znooredeen004 · Answer

Strangely enough this doesn't happen in the sample data. Its an excel file I have for work. In the excel file there are no decimal points or anything. Field is designated as string and has value like:

ABC123

123455

SAMPLE453

9876

Alteryx only turns 123455 or 9876 into 123455.0 and 9876.0 while leaving the other values in tact..

alexnajm · Answer

Can you send us the workflow replicating this behavior? It can just be a sample to make it easier