Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have a table like below
Input:
Load * Inline [
Key,Status,Amount1,Amount2
145,Yes,10.2,50
145,No,14.2,40
];
from the above table I need to extract the fields like below. Please help me on this.
Expected output:
Key Status_Yes(Amount1) Status_No(Amount1) Staus_Yes(Amount2) Status_No(Amount2)
145 10.2 14.2 50 40
Thanks in advance
i am not sure what the problem is. Load the data as is and create a table with the relevant expressions. Or is there more to this issue?