Add custom column a created datatable

Fri, 16 Nov 2012 11:39:10 GMT

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.

topic Add custom column a created datatable in QlikView

Add custom column a created datatable