Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Peony
Contributor

Field values joined suddenly after loding script

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?

Labels (1)
1 Solution

Accepted Solutions
anushree1
Valued Contributor

Re: Field values joined suddenly after loding script

Please try the below script:

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

8 Replies
Partner
Partner

Re: Field values joined suddenly after loding script

Try like this

LOAD Text(F1) as F1 INLINE

[

F1

9966

00009966 ];

You Know What To Do.
Partner
Partner

Re: Field values joined suddenly after loding script

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
];

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Peony
Contributor

Re: Field values joined suddenly after loding script

The same reuslt, unfortunatly

Peony
Contributor

Re: Field values joined suddenly after loding script

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

anushree1
Valued Contributor

Re: Field values joined suddenly after loding script

Please try the below script:

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

Peony
Contributor

Re: Field values joined suddenly after loding script

Allready tried. The result is the same.

anushree1
Valued Contributor

Re: Field values joined suddenly after loding script

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

clipboard_image_0.png

 

Is this not the expected result

Peony
Contributor

Re: Field values joined suddenly after loding script

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