1 Reply Latest reply: Oct 12, 2018 1:39 AM by Jonathan Dienst RSS

    cross load/Generic load help

    Mahitha M

      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