topic Re: Very Starnge regarding un structured data in QlikView

Very Starnge regarding un structured data

Fri, 14 Oct 2016 18:22:32 GMT

Hi all i have the db query

SELECT CATGR,sum(population) FROM mytable
where upper(RTRIM(CATGR)) = UPPER('Missing Doc') and ctry_name='us' and date ='01-JAN-16' group by CATGR

output in sql db is Missing Doc = 152

when i'm loading data into qlikview the sum(CATGR) as 152 (may be because of un structured data)

when i'm running the below query

SELECT CATGR,sum(population) FROM mytable
where CATGR='Missing Doc' and ctry_name='us' and date ='01-JAN-16' group by CATGR
output is Missing Doc = 83

i want my sum(CATGR) as 83

any idea on how to load unstructured data into qlikview

please help me out

Re: Very Starnge regarding un structured data

marcus_sommer — Sat, 15 Oct 2016 13:39:52 GMT

It's not quite clear to me what you are trying to do and what your issue is. But upper(RTRIM(CATGR)) = UPPER('Missing Doc') isn't the same like CATGR='Missing Doc' and might be therefore return other/more records which are then be aggregated. Maybe it's easier for testings to load the data without those condition and then to examine them within a tablebox and afterwards you could adjust your condition to get the really wanted records.

- Marcus

Re: Very Starnge regarding un structured data

Sat, 15 Oct 2016 13:55:36 GMT

Hi Marcus, Thank you for the response actually my problem is i want to load the spaces in DB into qlikview as it is.

I got the solution for that

Thanks for the quick response anyway i got some knowledge by your comments