Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
you can put all the code?
you can check the script error by generating log file.
go to "Document Properties"=> tick "Generate log"...
then run the script..
log file will generate in the same folder of your qvw file.
check logs......
this is the simplest way to check the script error...
-Nilesh
I used the log option to find the solution.
Thanks.