I have the following code
there must be an error because QV said so but without a clue only script failed.
I tried it also in debug mode.
I have missing data which I want to get rid off using an extra join.
Data is as follows:
Employees key employee_id
Career_learning training code (not all employees have training data)
Mandatory training (a set of 😎 records is left joined with career learning. When there is no career_learning data I miss entries in my table (since the mandatory trainings is vanisched because of the join).
So I want to do it like this:
employee left join with training data and left join this with career data
LJCareer_learning:
LOAD Distinct
EMPLOYEE_ID
RESIDENT Employees;
LEFT JOIN (LJCareer_learning)
LOAD
TRAINING_CODE,
TRAINING_NAME,
TRAINING_REGISTRATION_STATUS,
TRAINING_COMPLETION_YEAR,
TRAINING_COMPLETION_MONTH,
TRAINING_COMPLETION_YYYYMM
RESIDENT Career_Learning;
When I take this code out no errors. But what can be wrong.
I want to make a left join on LJcareer_learning with the mandatory training. The career learning tabel is all training data for employee. There are employees without no training.
John
