Second left Join not populating table

slamster44 — Tue, 20 Aug 2019 14:49:28 GMT

I am joining two different tables back to a master table and trying to populate a new field called "Bucket"

When I join the first table (Invoices), it populates the Bucket column with the correct data

When I join the second table (Payments), it populates Bucket as null value.

I also am joining the Payments back to itself to see if the column is populating and it is.

Why is my second join not working?

Re: Second left Join not populating table

dplr-rn — Wed, 21 Aug 2019 13:59:38 GMT

As i see it. you are joining on same table Transactions twice to populate same column Aging. but second join essentially messes with first one because the column Bucket is already there.

Create 1 table with TranNo and Bucket (concatenate date from both Invoice and Payments) . And perform 1 left join

topic Second left Join not populating table in QlikView

Second left Join not populating table

Re: Second left Join not populating table