10 Replies Latest reply: May 7, 2013 8:53 AM by educe mail RSS

    Adding an additional column via Script

      Dear Community,

       

      again i am confronted with a problem i'm not able to solve.

       

      I'm exporting a number of figures from a Excel-File with the following columns:

      --

      Year

      Month

      Cost Center

      Value

      --

      The corresponding Load-Script looks basically like this:

      --

      directory

      load

           Year,

           Month,

           Cost Center,

           Value

      from ...

      --

      My question is, how can i add one more column to the load, which has always the same value?

      The "artificial" Table should look like this:

       

      Datatype

      Year

      Month

      Cost Center

      Value

       

      Datatype is a constant value: "IST"

       

      Thanks in advance and kind regards,

      donuteater