4 Replies Latest reply: Nov 28, 2015 7:32 PM by Marco Wedel RSS

    Load column with a hardcoded value

    Chris Greenwood

      Hi,

       

      I have a table in the below format:

      IDValue
      1

      100

      2500
      3200
      4150
      5700

       

      I need to append a column to this table which has a value hardcoded into, a default value if you will.

      So the result I am trying to achieve is this:

      IDValuePeriod
      1100ONE_YEAR
      2500ONE_YEAR
      3200ONE_YEAR
      4150ONE_YEAR
      5700ONE_YEAR

       

      I've googled around for a bit, seems like Inline Loads might have something to do with it, but I can't figure it out.

       

      Any help would be much appreciated

       

      Thanks