topic Re: Field values joined suddenly after loding script in QlikView

Field values joined suddenly after loding script

Peony — Sat, 16 Nov 2024 02:33:17 GMT

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 — Fri, 06 Sep 2019 05:53:43 GMT

Try like this

LOAD Text(F1) as F1 INLINE

[

9966

00009966 ];

Vegar — Fri, 06 Sep 2019 05:56:18 GMT

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 — Fri, 06 Sep 2019 06:11:25 GMT

The same reuslt, unfortunatly

Peony — Fri, 06 Sep 2019 06:12:27 GMT

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

anushree1 — Fri, 06 Sep 2019 06:35:54 GMT

Please try the below script:

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

Peony — Fri, 06 Sep 2019 06:37:58 GMT

Allready tried. The result is the same.

anushree1 — Fri, 06 Sep 2019 06:40:16 GMT

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

Is this not the expected result

Peony — Thu, 12 Sep 2019 08:01:41 GMT

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