Convert scientific notation

[Anonymous]

Hi all!

I have encountered following issue. I have a folder with .xlsx files, where numbers are stored in a scientific notation, like so:

Tag	ID
#example1	1.06E+18
#example2	1.06E+18
#example3	1.06E+18
#example4	1.06E+18

I also have another folder with .xlsx files, where I have the very same numbers stored as integers. I want to join these two folders inside qlik, so I can have column "Tag" added to my main dataset. The problem is,when I try to use column "ID" as a key, values from these two different sources do not match. How can I convert scientific value (the all are in fact integers, not floats, like 1026146479358718000) to appropriate format?

Thanks in advance! 

[hector]

Hi!
Try with the num() function.
Example
num(1e4) returns 10000

[Anonymous]

Hello!

It didn't do the job.  For a file attached, I tried following:

Test_tags:
LOAD
    Tag,
    Num(Id)
FROM [lib://test_path/test_tags.xlsx]
(ooxml, embedded labels, table is Sheet1);

And result looks like this:

 

[hector]

How about this?

num(Id,'###################') as Id_Num