0 Replies Latest reply: Nov 16, 2012 6:39 AM by Nikolaos Kavroulakis RSS

    Add custom column a created datatable

      Hi there qlikview community,

       

      I have 2 tables:

       

      Validators_Boundaries:

      LOAD          Validator,

                          Sensor,

                          SensorParam,

                          High,

                          Low;

       

       

      SQL SELECT *

      FROM `list_a`.`initlimits`;

       

      nv200_Data:

      INNER JOIN (Validators_Boundaries)

      LOAD          TestID,

                    TestDate,

                    Month(TestDate) as TestMonth,

                    Year(TestDate) as TestYear,

                    Week(TestDate)as TestWeek,

                    SensorName AS Sensor,

                    SensorParam,

                    SensorValue;

       

      SQL SELECT

                    SensorStats.TestID,

                    SensorStats.TestDate,

                    SensorValues.SensorName,

                    SensorValues.SensorParam,

                    SensorValues.SensorValue

      FROM `office_a_log`.`nv200_init_sensor_header` AS SensorStats

      JOIN `office_a_log`.`nv200_init_sensor_log` AS SensorValues

      ON SensorStats.TestID = SensorValues.TestID;

       

       

      What i want to do is to add another field in both tables called lets say joinName that has a value that i can configure like set it joinName='question',

      in order to be able to join the tables by this field which will be the key.Any Ideas????

       

      Thanks in advance.