qvd loading more rows than it contains?

[adamdavi3s]

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?

[swuehl]

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

Like, posting the two complete document logs?

[adamdavi3s]

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

[adamdavi3s]

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

[stabben23 · Accepted solution]

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

[adamdavi3s]

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

[adamdavi3s]

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