Populate missing cells in load script

[#1]

Hi

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.

[johnw · Accepted solution]

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;

[#3]

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