5 Replies Latest reply: Oct 17, 2014 6:36 AM by cath elliott RSS

    flags and cross tables with nulls

      I have successfully created a cross table of 'final sites' but I also need
      to include data where the field is null (although I have replaced with text in
      resident table) as well as 'y' (I only want to exclude where the field = 'n')

       

      In the resident Main_Table where the field is null I have added text
      values that say 'not entered'

       

      I have used the following..

       

       

       

      CroTables:

      CrossTable (site_code,Flag,1)
      LOAD
      [Assignment Number],
      [YCH G],
      [BWM G],
      [BRN G],
      [LWH G],
      [Velindre BRN],
      [Clywedog LWH],
      [Fan Gorau MCI]
      Resident Main_Table;

      FinalSites:
      NoConcatenate LOAD * Resident
      CroTables
      where Flag =
      'y';

      DROP table
      CroTables;