adding prefix 0 while loading from SQL to Qlikview

[Anonymous]

Hi experts,

I am pulling this data from SQL into Qlikview using basic select * from abc statement. The issue is for CTCRSZ, I m getting '001' in both the rows in qlikview while in SQL one row has CTCRSZ '01' and another '001'.

CTACVL	CTCREX	CTCRSZ	CTCRTP	CTCTDS	CTCTVL	CTCTWT
3036		001	CFP	Standard Carton	3036	2
99999	DEF	001	CFP	DEFAULT CARTON	99999	0

Could you suggest how to fix the issue. Any help is much appreciated!

[sunny_talwar · Accepted solution]

When you run the SQL query you don't see the same issue? May be bring it explicitly as text -> Text(CTCRSZ)

[Anonymous]

Everything is pulled in text format.

[sunny_talwar]

What if you try something like this in the SQL Query (not sure what the SQL syntax is, but try the idea)

LOAD Right(CTCRSZ, Len(CTCRSZ) - 1) as CTCRSZ;

SQL SELECT

     1 & Text(CTCRSZ) as CTCRSZ

FROM SOURCE

[trdandamudi]

It is weird..... Try to bring in a Row Number and see what happens..

[Anonymous]

Actually when I was experimenting I put Text(CTCRSZ) in sql but that did not work. I try your code again.

[Anonymous]

nop...doesnt work

[sunny_talwar]

Doesn't work? Error or the same issue of 001?

[trdandamudi]

Did you run the SQL query by itself and checked the results ?

[Anonymous]

I was asking one of my friends to do that but I will check by myself