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:
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?
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)