I have data that looks like:
Contract ID |
12345 |
12AB03 |
TBD |
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 ID |
12345.0 |
12AB03 |
TBD |
How do I stop alteryx from adding that decimal point..
Can you send us the workflow replicating this behavior? It can just be a sample to make it easier
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..
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.