3 Replies Latest reply: Nov 4, 2013 7:48 AM by Bill Markham RSS

    Extra data with crosstable

    Bill Markham

      Hi

       

      I have Crosstable() that works fine :

       

      /////////////////////////////////////////////////////////////////////////

      DQD :

      /////////////////////////////////////////////////////////////////////////

      CrossTable( [Flag Name], [Value] ,1)

      load

        [Flight ID] ,

        [First Bag Missing Data Flag]   as [First Bag Missing Data] ,

        [Last Bag Missing Data Flag] as [Last Bag Missing Data]

      resident  Data.Quality

      ;

       

      But............. there are some extra dimension fields in the Data.Quality table that I would like included in the DQD table.

       

      Any suggestions how to do it without re-loading the DQD table ?

       

       

      Best Regards,     Bill

        • Re: Extra data with crosstable
          Fred Schonenberg

          Hi Bill,

          What's wrong with reloading Data.Quality?
          You're already loading from resident.

          /////////////////////////////////////////////////////////////////////////
          DQD :
          /////////////////////////////////////////////////////////////////////////
          CrossTable( [Flag Name], [Value] ,1)
          load
            [Flight ID] ,
            [First Bag Missing Data Flag]   as [First Bag Missing Data] ,
            [Last Bag Missing Data Flag] as [Last Bag Missing Data]
          resident  Data.Quality
          ;


          left join
          Load [Flight ID],
            ExtraDim1,
            ExtraDim2
          resident  Data.Quality
          ;

          • Re: Extra data with crosstable
            Gysbert Wassenaar

            Put the extra fields in front of the fields that should be pivoted and increase the last parameter to the number of columns that shouldn't be modified

             

            /////////////////////////////////////////////////////////////////////////

            DQD :

            /////////////////////////////////////////////////////////////////////////

            CrossTable( [Flag Name], [Value] ,4)

            load

              ExtraField1, ExtraField2, ExtraField3,

              [Flight ID] ,

              [First Bag Missing Data Flag]  as [First Bag Missing Data] ,

              [Last Bag Missing Data Flag] as [Last Bag Missing Data]

            resident  Data.Quality