topic Key and string should be a reference in QlikView https://community.qlik.com/t5/QlikView/Key-and-string-should-be-a-reference/m-p/729362#M675564 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using emailId (string)-Autonumber# generating a key, with this I am integrating the data with other tables.. So,we are missing the data which are not matched with these email ID's and I suggested them to include a primary key in table, and we starting including Key starting at this moment. Is it possible to check one of these keys to show data with out eliminating previous data ?</P></BODY></HTML> Tue, 22 Jul 2014 20:09:49 GMT Anonymous 2014-07-22T20:09:49Z Key and string should be a reference https://community.qlik.com/t5/QlikView/Key-and-string-should-be-a-reference/m-p/729362#M675564 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using emailId (string)-Autonumber# generating a key, with this I am integrating the data with other tables.. So,we are missing the data which are not matched with these email ID's and I suggested them to include a primary key in table, and we starting including Key starting at this moment. Is it possible to check one of these keys to show data with out eliminating previous data ?</P></BODY></HTML> Tue, 22 Jul 2014 20:09:49 GMT https://community.qlik.com/t5/QlikView/Key-and-string-should-be-a-reference/m-p/729362#M675564 Anonymous 2014-07-22T20:09:49Z Re: Key and string should be a reference https://community.qlik.com/t5/QlikView/Key-and-string-should-be-a-reference/m-p/729363#M675565 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>You can create separate fields with different names in addition in each table to represent the key values from the particular table. Then you can use exists() function to check whether the value exists already or not.&nbsp; </P></BODY></HTML> Tue, 22 Jul 2014 21:25:25 GMT https://community.qlik.com/t5/QlikView/Key-and-string-should-be-a-reference/m-p/729363#M675565 whiteline 2014-07-22T21:25:25Z