Alteryx Result Window Converts text Input to Scientific number

Question

Hi Team,

I have close to 1 lk records input. I have column with Unique ID which has unique IDs in below text format as shown in screen shot. Alteryx is converting it to Scientific format. I am converting the column to V_WString and 255 characters. Appreciate any help.

hemant86 · Answer

Thanks @DataNath for the suggestion. I just tried that but it still gives me the output in scientific.

DataNath · Answer

Hey @hemant86, have you tried the fixes suggested here? https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Converting-Values-from-Scientific-E-Notation/ta-p/21885