2 Replies Latest reply: Dec 12, 2012 4:45 PM by Mayil Vahanan Ramasamy RSS

    Add column when loading with if

      Hi

       

      I have a column: Otstanding_amount

       

      I would like to add an another column named Status with a script. This column needs to be filled in automatically as follows:

      "Outstanding amount to be payed" when the value of Outstanding_amount is not zero

      "Payed" when the outstandin amount is zero

       

      Here is my script:

       

      LOAD [Invoice number],

                [Total amount],

                Outstanding_amount

                ?????? as Status

      FROM

      $(My_Path)\Tabel 2.2 Clients.xlsx

      (ooxml, embedded labels, table is [xls-1212-140305]);