Field values joined suddenly after loding script

[Peony]

Hi All

I have a table with numbers like this

LOAD * INLINE [
F1
9966
00009966
];

When I executed the script, as the result I have only one row - 9966. But I still need both values. What can I do, to keep them both at the result?

[Vengatesh]

Try like this

LOAD Text(F1) as F1 INLINE

[

F1

9966

00009966 ];

[Vegar]

You still got two rows, but with identical values. Try to calculate count(F1), it  should be equal to 2.

Try this to fix your issue:

LOAD text(F1) as F1 INLINE [
F1
9966
00009966
];

[Peony]

The same reuslt, unfortunatly

[Peony]

Yes, I still have 2 rows, but they both like '9966'. Even after text().

[anushree1 · Accepted solution]

Please try the below script:

Load Text(F1) as F1;
LOAD * INLINE [
F1
9966
00009966
];

[Peony]

Allready tried. The result is the same.

[anushree1]

I see the belo result on using the code i shared:

Is this not the expected result

[Peony]

Tried once more and it works! Maybe I just missed something during the first check. Thank you very much for help.