Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover the Trends Shaping AI in 2026: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

WHERE EXISTS

Hi,

is there a possibility I can make find out about the exact nr., of associations between two tables?

Let me try to explain: If I have two tables and I use an EXISTS() option to load from table B only those records where a value from a specific field in table A exists in a specific field in table B

<=> Then I have all the records from table B where that value from a specific field in some record in table A exists

<=> But I do not know whether every record in table A has one or several records in table B associated to it, there might be some records in table A that do not have a representation in table B. To find out about those, I need to use the EXISTS() option a second time while doing the LOAD the other way round - then I have only those records in table A which do have representations in table B.

Is there any simpler way to get to this point?

Thanks a lot!

Best regards,

DataNibbler

2 Replies
marcus_sommer

Hi DataNibbler,

maybe an inner join on this key between both tables is an alternatively.

- Marcus

datanibbler
Champion
Champion
Author

Yep - I guess the result should be the same. I'll try.