Input Data Number showing 1.00xxxEB

Question

Hi,

Need help for this. The input is an excel format report (downloaded Google Sheet), one column is ID number, which in excel showing like "600123456""600234567"....but once it connected to Alteryx, the ID number showing as "1.00XXXXXEB""1.000XXXXXE"... thinking might be because of gsheet and excel compatibility.

Is there a solution in Alteryx to add a tool or formula to edit/clear format or convert the random 1.000xxxx into the correct ID number?

Qiu · Answer

@fanglan 
Can you provide a snap shot or sample file so we can replicate the error?

I tried with the Google Spreadsheet, it ended up exported XLSX after all.

Alteryx does have an issue with large numbers though.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Large-numbers-are-dropped-when-importing/td-p/485306