topic Ms Access in QlikView

Ms Access

Fri, 03 Dec 2010 17:43:43 GMT

hello guys,

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.

Ms Access

Fri, 03 Dec 2010 17:47:24 GMT

The simplest way is in your load use "field AS new_fieldname" to differentiate between versions of fields you do not want QlikView to join.

This associative linking by field name is the way the product works and has a lot of power once you get used to it.

Ms Access

Fri, 03 Dec 2010 18:09:58 GMT

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,

QUALIFY *;
Table1:
LOAD
Field1,
Field2,
Field3
FROM..........................................;

This will result in fields being loaded as 'Table1.Field1' etc . If & when you want to stop this behaviour you need to employ Unqualify followed by the last table name eg UNQUALIFY Table1;

Ms Access

Tue, 21 Dec 2010 17:19:31 GMT

thanks a lot