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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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