Hai i had two source fil. One is Excel and another is QVD. I had the values as follows.
My Output should be as follows:
|Category||Excel Value||QVD Value|
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?
Use below script
Value as Value1
If(Category='A','A-B',IF(Category='B','A-B',Category)) as Category,
Value as Value2
Now create a straight Table
Dimension = Category