topic Re: Joining distinct values in QlikView https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7875#M607723 <HTML><HEAD></HEAD><BODY><P>Use Autonumber(ID) AS KeyID</P></BODY></HTML> Tue, 30 Jan 2018 19:02:02 GMT vishsaggi 2018-01-30T19:02:02Z Joining distinct values https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7869#M607717 <HTML><HEAD></HEAD><BODY><P>I have a table with ID 01, 001, and 0001</P><P>I have another Table using one of those IDs.&nbsp; when I join the tables I see all three joined.&nbsp; Is there a way around this?</P></BODY></HTML> Fri, 26 Jan 2018 18:03:48 GMT https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7869#M607717 Anonymous 2018-01-26T18:03:48Z Re: Joining distinct values https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7870#M607718 <HTML><HEAD></HEAD><BODY><P>Use Text(ID) for join, in both table.</P><P></P><P>regards</P></BODY></HTML> Fri, 26 Jan 2018 18:09:41 GMT https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7870#M607718 tiago_juncioni 2018-01-26T18:09:41Z Re: Joining distinct values https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7871#M607719 <HTML><HEAD></HEAD><BODY><P>unfortunately, this did not work.&nbsp; Is there another way?</P></BODY></HTML> Fri, 26 Jan 2018 23:26:05 GMT https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7871#M607719 Anonymous 2018-01-26T23:26:05Z Re: Joining distinct values https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7872#M607720 <HTML><HEAD></HEAD><BODY><P>What about this:</P><P></P><P>Replace ('ID','0','X') as NewID</P><P></P><P>In both table.</P></BODY></HTML> Sat, 27 Jan 2018 01:56:53 GMT https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7872#M607720 Thiago_Justen_ 2018-01-27T01:56:53Z Re: Joining distinct values https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7873#M607721 <HTML><HEAD></HEAD><BODY><P>Did you try Text(ID) in the load script from the original source?</P><P>What is the source?</P></BODY></HTML> Mon, 29 Jan 2018 23:49:20 GMT https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7873#M607721 dwforest 2018-01-29T23:49:20Z Re: Joining distinct values https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7874#M607722 <HTML><HEAD></HEAD><BODY><P>the data is coming from a qvd File.</P></BODY></HTML> Tue, 30 Jan 2018 18:47:53 GMT https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7874#M607722 Anonymous 2018-01-30T18:47:53Z Re: Joining distinct values https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7875#M607723 <HTML><HEAD></HEAD><BODY><P>Use Autonumber(ID) AS KeyID</P></BODY></HTML> Tue, 30 Jan 2018 19:02:02 GMT https://community.qlik.com/t5/QlikView/Joining-distinct-values/m-p/7875#M607723 vishsaggi 2018-01-30T19:02:02Z