Merging Rows

[#1]

Hai i had two source fil. One is Excel and another is QVD. I had the values as follows.

Excel:                    

Category	Value
A-B	6
C	4

QVD:

Category	Value
A	2
B	5
C	5

My Output should be as follows:

Category	Excel Value	QVD Value
A-B	6	7
C	4	5

Need to make QVDs A and B value as A-B value and i need to get the above result. Could anyone answer me pls?

[MK_QSL]

Use below script

===============

Excel:

Load

  Category,

  Value as Value1

Inline

[

  Category, Value

  A-B, 6

  C, 4

];

QVD:

Load

  If(Category='A','A-B',IF(Category='B','A-B',Category)) as Category,

  Value as Value2

Inline

[

  Category, Value

  A, 2

  B, 5

  C, 5

];

==========================

Now create a straight Table

Dimension = Category

Expressions

1) SUM(Value1)

2) SUM(Value2)