WHERE EXISTS

datanibbler — Thu, 22 Jun 2017 12:18:07 GMT

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

Re: WHERE EXISTS

marcus_sommer — Thu, 22 Jun 2017 12:28:14 GMT

Hi DataNibbler,

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

- Marcus

Re: WHERE EXISTS

datanibbler — Fri, 23 Jun 2017 08:20:03 GMT

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

topic Re: WHERE EXISTS in QlikView

WHERE EXISTS

Re: WHERE EXISTS

Re: WHERE EXISTS