topic Re: adding prefix 0 while loading from SQL to Qlikview in QlikView

adding prefix 0 while loading from SQL to Qlikview

Anonymous — Fri, 29 Apr 2016 15:55:36 GMT

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!

Re: adding prefix 0 while loading from SQL to Qlikview

sunny_talwar — Fri, 29 Apr 2016 15:57:55 GMT

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

Re: adding prefix 0 while loading from SQL to Qlikview

Anonymous — Fri, 29 Apr 2016 16:00:20 GMT

Everything is pulled in text format.

Re: adding prefix 0 while loading from SQL to Qlikview

sunny_talwar — Fri, 29 Apr 2016 16:04:54 GMT

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

Re: adding prefix 0 while loading from SQL to Qlikview

trdandamudi — Fri, 29 Apr 2016 16:06:01 GMT

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

Re: adding prefix 0 while loading from SQL to Qlikview

Anonymous — Fri, 29 Apr 2016 16:08:58 GMT

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

Re: adding prefix 0 while loading from SQL to Qlikview

Anonymous — Fri, 29 Apr 2016 16:10:36 GMT

nop...doesnt work

Re: adding prefix 0 while loading from SQL to Qlikview

sunny_talwar — Fri, 29 Apr 2016 16:12:09 GMT

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

Re: adding prefix 0 while loading from SQL to Qlikview

trdandamudi — Fri, 29 Apr 2016 16:15:33 GMT

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

Re: adding prefix 0 while loading from SQL to Qlikview

Anonymous — Fri, 29 Apr 2016 16:19:15 GMT

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

Re: adding prefix 0 while loading from SQL to Qlikview

Anonymous — Fri, 29 Apr 2016 16:24:37 GMT

error

Re: adding prefix 0 while loading from SQL to Qlikview

Anonymous — Mon, 02 May 2016 18:17:08 GMT

Hey just wanted to inform you guys, this issue was caused by some server issues that is fixed now. We are using Qlik10 and recently db folks ran some update that triggered the report distortion. I appreciate your time and effort.