Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When loading data from a databases, I have a table with my articles which each have a unique itemno, which is alfa-numerical (character).
In my database, I have an item with itemno "850" and one with itemno "00850".
When loading this into QlikView (qvd files), QlikView loads them both as "00850", and thereby eveyr report based on itemno is wrong.
When i adapt the SQL load statement to say "... where ITEMNO = '850', only 1 item is loaded and displayed as "850", when it says "... where ITEMNO = '00850' also only 1 item is loaded en now displayed as "00850" (correct)
How can I make QlikView load my items correctly, that is, without chaging the value of any field?
Thx,
Yves.
Hi
Try this one
Tab1:
Load FIRMANR, ARTNR, text(ARTNR) as ARTNR_t, GROEP1;
SQL SELECT FIRMANR, ARTNR, GROEP1 FROM PUB.ARTI;
Thanks
Saran.
Hi, have you tried the text() function?
Use
Load
*,
text(ITEMNO) as ITEMNO_T
;
SQL
Select from...;
This will keep the leading zeroes of the record.
Rgds
Hi,
I tried now, but I get een error msg then.
This is the SQL statement:
Artikel:
SQL SELECT
FIRMANR,
ARTNR,
text(ARTNR) as ARTNR_t,
GROEP1
FROM PUB.ARTI;
The error is "syntax error in sql statement".
The field i'm having trouble with is "ARTNR"
Regards,
Yves.
Hi
Try this one
Tab1:
Load FIRMANR, ARTNR, text(ARTNR) as ARTNR_t, GROEP1;
SQL SELECT FIRMANR, ARTNR, GROEP1 FROM PUB.ARTI;
Thanks
Saran.
try this
Artikel:
Load
FIRMANR,
ARTNR,
text(ARTNR) as ARTNR_t,
GROEP1
;
SQL SELECT
FIRMANR,
ARTNR,
GROEP1
FROM PUB.ARTI;
Text() is a QV function, so it must be placed into a Load statement rgds
Off course.
Thx a lot Saran and Héctor.
Regards,
Yves.