I am new to qlikview, and iam trying to learn qlikview. i have a database in ms Acces, i have uploaded the tables using the sql. qlick is automaticaly connecting the tables and because of this some of the values are dulipcated. i am using the personal edition so i cant use other examples. i want to remove synthetic keys and add myown joins (left join)
can you please provide me a solution and also some examples, not .qvw file, the script for ms access loading.
Hi, You could also use Qualify as part of 'your' load script which will result in something you will be used to as a database user ie TableName.FieldName & by using * you get around having to rename all the fields being loaded. For example,