Extra data with crosstable

[Anonymous]

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

[fred_s]

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
;

[Gysbert_Wassenaar · Accepted solution]

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

[Anonymous]

G

Brilliant - works perfectly.

I was wondering earlier what that third numeric parameter did, thanks to you I now know.

Many Thanks,     Bill