topic Populate missing cells in load script in QlikView

Populate missing cells in load script

Fri, 05 Nov 2010 12:36:47 GMT

I have to populate some missing cells in a table but can't get my head around how to do it. I have 4 tables: One (Audit) showing what has been changed in the other 3 tables and by who.

My problem is that one of the 3 tables (DiscountDetail) doesn't contain client information which I need to show. DiscountDetail is a "sub-table" of the table Discount and they have DiscountNo/DiscountNoDetail in common and Discount has client information.

How do I get to show the client information for the table DiscountDetail. Please see enclosed.

Populate missing cells in load script

johnw — Fri, 05 Nov 2010 21:33:52 GMT

If I understood the question, and assuming you only have one row on the Discount table for each DiscountNo:

LEFT JOIN (DiscountDetail)
LOAD
DiscountNo as DiscountNoDetail
,ClientID2 as ClientID3
RESIDENT Discount;

Populate missing cells in load script

Sat, 06 Nov 2010 00:08:26 GMT

Hi,

I am not quite sure but I think this is it what you are looking for:


LEFT JOIN (DiscountDetail)
LOAD
 ClientID2,
 DiscountNo as DiscountNoDetail
RESIDENT Discount;

Regards, Roland