Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I'm going to be crazy. I've to tables:
Budget
YEAR Month Category QtyBudget
2011 10 AAA 10
2011 11 BBB 12
2011 9 CCC 5
Actual
YEARA MonthA Family SalesQty
2011 5 AAA 12
2011 10 AAA 5
2011 7 BBB 5
2011 11 DDD 15
I'd like to merge them but I don't know how. I tried by join, concatenate, but it doesn't work fine.
Does anybody have any good trip in order to help me ?
Thanks in advance
Try this
Budget:
Load * Inline [
YEAR , Month , Category , QtyBudget
2011 , 10 , AAA , 10
2011 , 11 , BBB , 12
2011 , 9 , CCC , 5] ;
Outer Join(Budget)
Load * Inline [
YEAR , Month ,Category , SalesQty
2011 , 5 , AAA , 12
2011 , 10 , AAA , 5
2011 , 7 , BBB , 5
2011 , 11 , DDD , 15] ;
Or this
Load * , 'Budget' as Indicator Inline [
YEAR , Month , Category , Value
2011 , 10 , AAA , 10
2011 , 11 , BBB , 12
2011 , 9 , CCC , 5] ;
Concatenate LOad * , 'Actual' as Indicator Inline [
YEAR , Month ,Category , Value
2011 , 5 , AAA , 12
2011 , 10 , AAA , 5
2011 , 7 , BBB , 5
2011 , 11 , DDD , 15] ;
JJ