topic Re: How to Join two tables with out having unique values? in QlikView https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960894#M329794 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you attach sample data and your expected output then it will be easier to provide the solution.&nbsp; There may be many solutions like Mapping Load or Keep.</P><P></P><P>You can try those.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Thu, 20 Aug 2015 09:15:56 GMT jagan 2015-08-20T09:15:56Z How to Join two tables with out having unique values? https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960891#M329791 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>How to Join two tables with out having unique values?</P></BODY></HTML> Thu, 20 Aug 2015 08:01:40 GMT https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960891#M329791 d_koti24 2015-08-20T08:01:40Z Re: How to Join two tables with out having unique values? https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960892#M329792 <HTML><HEAD></HEAD><BODY><P>Could you explain with more details please?</P></BODY></HTML> Thu, 20 Aug 2015 08:04:34 GMT https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960892#M329792 alexandros17 2015-08-20T08:04:34Z Re: How to Join two tables with out having unique values? https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960893#M329793 <HTML><HEAD></HEAD><BODY><P>May be use Mapping Load instead of join. Will need to get more details, like looking at your current script before giving a more precise answer.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 20 Aug 2015 08:05:19 GMT https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960893#M329793 sunny_talwar 2015-08-20T08:05:19Z Re: How to Join two tables with out having unique values? https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960894#M329794 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you attach sample data and your expected output then it will be easier to provide the solution.&nbsp; There may be many solutions like Mapping Load or Keep.</P><P></P><P>You can try those.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Thu, 20 Aug 2015 09:15:56 GMT https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960894#M329794 jagan 2015-08-20T09:15:56Z Re: How to Join two tables with out having unique values? https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960895#M329795 <HTML><HEAD></HEAD><BODY><P>Did you try to build your own key - concatenated key in each table?</P><P>looking like the below example</P><P> system_of_customer_id &amp; '~' &amp; source_customer_id as %KEY_Customer</P><P></P><P>but as the guys before me mentioned, you have to provide more details. You should consider both join and ApplyMap, depending on how many columns you want to bring across.</P></BODY></HTML> Thu, 20 Aug 2015 09:16:29 GMT https://community.qlik.com/t5/QlikView/How-to-Join-two-tables-with-out-having-unique-values/m-p/960895#M329795 kuczynska 2015-08-20T09:16:29Z