Well,
In fact the behaviour of your script is normal :
The join and keep prefixes in the QlikView script language can be preceded
by the prefix left. If used before join , it specifies that the join between the two tables should be
a left join. The resulting table only contains combinations between the two
tables with a full data set from the first table.
If used before keep it specifies that the second table should be reduced to its
That is to say, when you make a left join, the result is stored in your first table. Is that good or bad ? It depends on what do you want to do with your data
About the synthetic keys : they are created automatically created when composite keys are needed to join your table (that is to say when the join is made upon severals fields between two tables). Is that bad or good ? Once again it depends about what you need :
If you agree with the fields used for the join. The result will be OK (except sometime some useless synthetic keys of synthetic keys appeared). QlikTech recommand to create your own synthetic key with the autonumber function
But anyway your questions are very general and the precise answer depend on what do you want to do and on your data model.
Anyway I advise you to first consult the reference manual looking for "Left join" and "synthetic keys".
hope it helps
Regards
