Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hai i had two source fil. One is Excel and another is QVD. I had the values as follows.
Excel:
QVD:
My Output should be as follows:
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
===============
Load
Category,
Value as Value1
Inline
[
Category, Value
A-B, 6
C, 4
];
If(Category='A','A-B',IF(Category='B','A-B',Category)) as Category,
Value as Value2
A, 2
B, 5
C, 5
==========================
Now create a straight Table
Dimension = Category
Expressions
1) SUM(Value1)
2) SUM(Value2)