Table Links

[#1]

Hi all

I am currently replicating a very complicated table structure into Qlikview which when all included creates over 29 synthetic keys and a ridiculous amount of links between tables that i do not need and will take me days to sort out!

Is there a way of disabling automatic links so that, much in the way Microsoft Access works, i am able to manually create links and then sort out the other fields out accordingly?

Any advice is much appreciated!

Regards,

Steven Prentice

[#2]

Hi,

try to use

QUALIFY *;

at the beginning of your load script - it takes the tablename and puts it in front of the fieldname (eg testtable.testfield), so you can avoid tables that share the same fieldnames to be linked automatically.

Regards,

Eva

[Sokkorn]

Hi,

Try this scenario

unqualify *;
select * from tab1;
select * from tab2;
select * from tab3;

Regards,

Sokkorn

[Anonymous]

http://michaelellerbeck.com/2008/08/22/qlikview-synthetic-keys/