topic Re: qvd loading more rows than it contains? in QlikView

qvd loading more rows than it contains?

adamdavi3s — Wed, 25 Nov 2020 16:16:04 GMT

This one has me baffled but I am sure there is a simple explanation.

This QVD is reporting as >80m rows, but has only had around 7m stored in it?

QVD log:

Front end log (note not pulling all columns):

When I do a sum(1) against the unique ID in a char some are reporting more than 1, but a table box with ALL fields in it shows only one line for it?

The only 'funky' thing I am doing is running a loop to rename all the fields (Append 'ord_' where the field doesn't start with a %) but I can't see how that would be messing with it?

Re: qvd contains more rows than saved?

swuehl — Fri, 03 Feb 2017 14:51:32 GMT

Could you post more details how you load the data, store to QVD, then reload in frontend?

Like, posting the two complete document logs?

Re: qvd contains more rows than saved?

adamdavi3s — Fri, 03 Feb 2017 14:55:11 GMT

I can't see any harm in that, but if you spot anything sensitive then please let me know!

For the front end, I have set up a test file which only pulls in this QVD, nothing else.

I'm just re-running it without the left join or field renaming to see if that is it

Re: qvd loading more rows than it contains?

adamdavi3s — Fri, 03 Feb 2017 15:07:11 GMT

Ok so it is the join or the rename which is causing the issue

Re: qvd loading more rows than it contains?

stabben23 — Fri, 03 Feb 2017 15:13:06 GMT

Hi Adam,

Could this part be used as an Mapping Load instead? Do You have Many Branch_Code on every POWHGUID in

DW_MEARS_ODS.ods.Procurement_Master table?

LEFT JOIN (Orders)

LOAD *

SQL SELECT

rtrim(ltrim(POWHGUID)) as POWHGUID,

Branch_Code

FROM DW_MEARS_ODS.ods.Procurement_Master

WHERE Is_Current =1

Re: qvd loading more rows than it contains?

adamdavi3s — Fri, 03 Feb 2017 15:18:04 GMT

Funny enough I have just changed it to a mapping load as it is the only thing I can think of, although it should be a 1-1 match.

I don't understand why this wouldn't show in the front end though

E.g. that row with "518" values should show as "518" rows in the table box

Re: qvd loading more rows than it contains?

adamdavi3s — Fri, 03 Feb 2017 15:20:59 GMT

Yep looks like that is the issue, back to check the DB!