Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

0 Replies