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

    Add column when loading with if



      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],


                ?????? as Status


      $(My_Path)\Tabel 2.2 Clients.xlsx

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