topic Re: Writing first query in QlikView https://community.qlik.com/t5/QlikView/Writing-first-query/m-p/1233751#M864203 <HTML><HEAD></HEAD><BODY><P>hi </P><P>Qlikview is joining field according to their names , </P><P>so you can go with this approach :</P><P>write in the script </P><P>Qualify *; - this will add the table name to all the fields </P><P>and than write another line</P><P>unqualify Key_Field ; -this will leave the key field name as in the source,</P><P>and so qlikview will only connect the tables according to this field </P></BODY></HTML> Sun, 25 Dec 2016 06:55:18 GMT lironbaram 2016-12-25T06:55:18Z Writing first query https://community.qlik.com/t5/QlikView/Writing-first-query/m-p/1233750#M864202 <HTML><HEAD></HEAD><BODY><P>My company just got me the QlikView developer tools for my desktop. Attaching a Teradata source was a snap with my system ODBC.</P><P></P><P>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.</P><P></P><P>My background is in Access so I am used to dragging the joins myself.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Writing-first-query/m-p/1233750#M864202 2020-11-25T16:16:04Z Re: Writing first query https://community.qlik.com/t5/QlikView/Writing-first-query/m-p/1233751#M864203 <HTML><HEAD></HEAD><BODY><P>hi </P><P>Qlikview is joining field according to their names , </P><P>so you can go with this approach :</P><P>write in the script </P><P>Qualify *; - this will add the table name to all the fields </P><P>and than write another line</P><P>unqualify Key_Field ; -this will leave the key field name as in the source,</P><P>and so qlikview will only connect the tables according to this field </P></BODY></HTML> Sun, 25 Dec 2016 06:55:18 GMT https://community.qlik.com/t5/QlikView/Writing-first-query/m-p/1233751#M864203 lironbaram 2016-12-25T06:55:18Z Re: Writing first query https://community.qlik.com/t5/QlikView/Writing-first-query/m-p/1233752#M864204 <HTML><HEAD></HEAD><BODY><P>In Qlikview we have Dynamic Association, any field with the same names from different tables will automatically be associated.</P><P>here is a link to downloading the reference manual (search for "Association")</P><P><A href="http://semanticommunity.info/@api/deki/files/24990/QlikView_Reference_Manual.pdf" title="http://semanticommunity.info/@api/deki/files/24990/QlikView_Reference_Manual.pdf">http://semanticommunity.info/@api/deki/files/24990/QlikView_Reference_Manual.pdf</A></P></BODY></HTML> Sun, 25 Dec 2016 07:57:08 GMT https://community.qlik.com/t5/QlikView/Writing-first-query/m-p/1233752#M864204 vinieme12 2016-12-25T07:57:08Z