Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
;
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
G
Brilliant - works perfectly.
I was wondering earlier what that third numeric parameter did, thanks to you I now know.
Many Thanks, Bill