2 Replies Latest reply: Jan 14, 2014 3:14 AM by Thorsten Schröder RSS

    Dealing with non-exisiting values in one of two tables

    Thorsten Schröder

      Hello community,

       

      I load two tables from a database and save each to a qvd. Both are connect through the ID-column name.

      Table Master contains the master data meaning that I only want to deal with the IDs of table B (Slave) where they match with A. For that I used Where Exists(ID, ID) in the slave table.


      The slave table contains measure values for each ID. If an ID of the master table is not present in the slave table I get wrong numbers when I do a distinct count to get the numbers for the MeasureType column.

       

      See this screenshot for details: Note: Here I don't use "where exists" to show you the complete example.

       

      measure.PNG.png

      The goal here is to deal with the non-existing IDs in the slave table (77, 88) so that "No measure" has a count of 3 instead 1.

      Would this work with joining only a subset of the columns from both tables or which way do I have to go here?

       

      I included my sample qvw so you can have a look.

       

      Thank you,

      Thorsten