Create a table box based on a condition

[#1]

I have two tables for which a created composite keys. Say transaction_id in  table 1 and record_id in the table 2.

I need all fields ( in the table box ) from table 1 for which transaction_id is not matched to any of the record_ids.

What would be the best way to do this?

[sunny_talwar]

Can you share how your data model looks like?

[sunny_talwar]

May be a snapshot from your tableviewer in QlikView

[annafuksa1]

Please look at attached file

!

[#5]

Sorry Sunny, I am not able to share my data model.

What I am looking for is, I guess, similar to NOT IN clause in SQL.

I would prefere not to do it using resident LOAD as the files are quite large.

Table box is not a mandatory. I can also show it as a straight table as long as this logic can be a part of the expression.

[annafuksa1 · Accepted solution]

it is better to use resident load and make all possible calcualtion in Scrript (if reload time is reasonable) as it will not slow downup your app, and do not having complicated  formula (as they can significantly slow down application) is quite beneficial.

if you want to use expression use:

only({<transaction_id-= p({1} record_id)>} transaction_id)

Anna