Budget vs. Actual

Wed, 21 Sep 2011 16:34:26 GMT

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

Wed, 21 Sep 2011 17:12:24 GMT

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