My Pivot Table is displaying incorrect value based on my set analysis

[jim_chan]

Hi guys,

I have created a sample qvw file with inline data as well. Basically I have 2 files. and need 2 expression.

1st expresssion is ok = to show how many time this record ID has visited the outlet. - data is from table transaction

2nd expression in the pivot is not correct = to show the the record ID CONFIRM purchase at which outlet. - data is from table confirmation, table 2.

my expectation result is , it should so 0 value on the blank outlet_visited row. because based on the confirmation data table 2, shows that record ID 12345, confirm purchased at ABC.

Please help guys....!

[jim_chan]

hi there,

i will create composite key, it works as well. thank you bro!

Rgds

Jim