topic Re: Problems when comparing two tables containing same fields in QlikView https://community.qlik.com/t5/QlikView/Problems-when-comparing-two-tables-containing-same-fields/m-p/925969#M979233 <HTML><HEAD></HEAD><BODY><P>That function is called Qualify. Use it with care.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14407809679834495" jivemacro_uid="_14407809679834495" modifiedtitle="true"> <P>Qualify * ;</P> <P></P> <P>TableX:</P> <P>LOAD *</P> <P>FROM ... ;</P> </PRE></BODY></HTML> Fri, 28 Aug 2015 16:56:18 GMT Gysbert_Wassenaar 2015-08-28T16:56:18Z Problems when comparing two tables containing same fields https://community.qlik.com/t5/QlikView/Problems-when-comparing-two-tables-containing-same-fields/m-p/925968#M979232 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Really hope you can help me.</P><P>I have two tables containing exactly the same fields, but are in different databases. I would like to compare them.</P><P></P><P>I have heard, there is a function where you can insert the table name in front of each field so they become unique.</P><P></P><P>Can you help me with the function and how to use it?</P><P></P><P>Your help will be very much appreciated!</P></BODY></HTML> Fri, 28 Aug 2015 08:52:51 GMT https://community.qlik.com/t5/QlikView/Problems-when-comparing-two-tables-containing-same-fields/m-p/925968#M979232 2015-08-28T08:52:51Z Re: Problems when comparing two tables containing same fields https://community.qlik.com/t5/QlikView/Problems-when-comparing-two-tables-containing-same-fields/m-p/925969#M979233 <HTML><HEAD></HEAD><BODY><P>That function is called Qualify. Use it with care.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14407809679834495" jivemacro_uid="_14407809679834495" modifiedtitle="true"> <P>Qualify * ;</P> <P></P> <P>TableX:</P> <P>LOAD *</P> <P>FROM ... ;</P> </PRE></BODY></HTML> Fri, 28 Aug 2015 16:56:18 GMT https://community.qlik.com/t5/QlikView/Problems-when-comparing-two-tables-containing-same-fields/m-p/925969#M979233 Gysbert_Wassenaar 2015-08-28T16:56:18Z Re: Problems when comparing two tables containing same fields https://community.qlik.com/t5/QlikView/Problems-when-comparing-two-tables-containing-same-fields/m-p/925970#M979234 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please check these threads.</P><P><A href="https://community.qlik.com/docs/DOC-7963">Do you Qualify?- How to use QUALIFY statement</A></P><P></P><P><A href="https://community.qlik.com/message/636138">Scenarios for Qualify</A></P><P><A href="https://community.qlik.com/thread/29254">qualify and unqualify</A></P></BODY></HTML> Sat, 29 Aug 2015 02:30:58 GMT https://community.qlik.com/t5/QlikView/Problems-when-comparing-two-tables-containing-same-fields/m-p/925970#M979234 qlikviewwizard 2015-08-29T02:30:58Z