alteryx is not reading the data as it is mentioned in the file. please help

[rag329]

Hi team ,

I am attaching the screenshots of the original data in the excel file and the one that I read in alteryx too.

my actual data looks like 0.00E+00 in excel file, 

when I read the file in alteryx, it shows as 1.....  

the file type is in double and even if i change the data type and size, it didnt change. 

I want it to read as it is 0.00E+00 when I read in alteryx too.... 

please help.

[Yoshiro_Fujimori · Accepted solution]

Hi @rag329 

Alteryx interprets Scientific Notation (00E+00) format as nubmer type data.

And 0.00E+00 is equalt to 0, as it represents 0.00*(0^0) = 0*1 = 0.

The sample workflow shows the same result.

So it seems to be working correctly to me.

If you are facing a case that 0.00E+00 results in 1, please send a sample workflow.

Text Input tool (Original data)

Text Input Tool (at Output Anchor)

[rag329]

Sure, @Yoshiro_Fujimori I am sending the workflow

[rag329]

Here is the original data and workflow... in original data it shows as 0.00E+00 but when I read it in alteryx it shows as 0 or 1. 

even when I read it in alteryx it has to show as 0.00E+00.   please go through the file and workflow and help me with that.  @Yoshiro_Fujimori 

[rag329]

@Yoshiro_Fujimori got it but is there any way that can be read the data 0.00E+00 as same when we read in alteryx.. like after running the workflow it show as same 0.00E+00

[binuacs]

@rag329 If you check the actual value in the excel formula bar for these scientific values is either 0 or 1, that is the same value you are seeing in the Alteryx. 

[binuacs · Accepted solution]

@rag329 If you want the exact value in Alteryx convert the file in to csv format and read in Alteryx

[rag329]

@binuacs thank you so much for the help team.