cross load/Generic load help

[mahitham]

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

[jonathandienst]

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?