Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please find below details.
How to find out this output.
I/P-
WD | PLANT | QTY |
A | X | 5 |
A | Y | 5 |
A | Z | 5 |
B | Y | 7 |
C | X | 2 |
C | Z | 5 |
O/P-
WD | PLANT | QTY |
A | XYZ | 15 |
B | Y | 7 |
C | XZ | 7 |
Try this :
Final:
Load
WD,
Concat(PLANT) as PLANT,
sum(QTY) as QTY
Resident Temp
Group by WD;