Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My company just got me the QlikView developer tools for my desktop. Attaching a Teradata source was a snap with my system ODBC.
My question is with the table connector. It either joined way too many fields or set up an entirely stupid connection that I cannot see how to disconnect.
My background is in Access so I am used to dragging the joins myself.
hi
Qlikview is joining field according to their names ,
so you can go with this approach :
write in the script
Qualify *; - this will add the table name to all the fields
and than write another line
unqualify Key_Field ; -this will leave the key field name as in the source,
and so qlikview will only connect the tables according to this field
hi
Qlikview is joining field according to their names ,
so you can go with this approach :
write in the script
Qualify *; - this will add the table name to all the fields
and than write another line
unqualify Key_Field ; -this will leave the key field name as in the source,
and so qlikview will only connect the tables according to this field
In Qlikview we have Dynamic Association, any field with the same names from different tables will automatically be associated.
here is a link to downloading the reference manual (search for "Association")
http://semanticommunity.info/@api/deki/files/24990/QlikView_Reference_Manual.pdf