Join issue

Tue, 09 Apr 2013 09:14:23 GMT

I have this in my load script:

MAN_TRAININGS:

LOAD Distinct

MAND_TRAINING_NAME,

MAND_TRAINING_CODE AS TRAINING_CODE,

MAND_TRAINING_GROUP

RESIDENT MandatoryTraining;

LEFT JOIN (MAN_TRAININGS)

LOAD

EMPLOYEE_ID

RESIDENT Career_Learning;

Now I don't see the training for employees when they have no training records.

In tha attachment my gauges. One is for colleagues having done the trainings and one is created for employees without training records (called mand_notokay). The table must look like the second image (mandokay.jpg) with 6 rows defined in table MAN_TRAININGS.

Thanks,

John

topic Join issue in QlikView

Join issue