topic Re: Replace Field Values with Hash in Fact Table.. ¿Is it a Good Idea? in QlikView https://community.qlik.com/t5/QlikView/Replace-Field-Values-with-Hash-in-Fact-Table-Is-it-a-Good-Idea/m-p/725426#M1071164 <HTML><HEAD></HEAD><BODY><P>Or is it better to use the "Text" value instead a Hash?</P><P>Or is any other way to do that?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 22 Aug 2014 16:04:19 GMT cristian_av 2014-08-22T16:04:19Z Replace Field Values with Hash in Fact Table.. ¿Is it a Good Idea? https://community.qlik.com/t5/QlikView/Replace-Field-Values-with-Hash-in-Fact-Table-Is-it-a-Good-Idea/m-p/725425#M1071163 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have three fact tables, but I don't have ID for some fields, just the "Text".</P><P>As I need to compare values between the fact tables, I've reader some articles that use link tables to compare.. But all of the uses the ID of the fields. I'm trying to use <STRONG>Generic keys</STRONG> to solve the problem (I accept any other suggestion!).</P><P>So I wonder if it is a good idea to "Create" an ID for my field using a Hash Function?</P><P>Or it is something stupid and I should not do it?</P><P></P><P>Thanks</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3451">Generic keys</A></P><P><A href="https://community.qlik.com/thread/63862">Multiple fact tables, same dimensions</A></P></BODY></HTML> Thu, 21 Aug 2014 21:35:02 GMT https://community.qlik.com/t5/QlikView/Replace-Field-Values-with-Hash-in-Fact-Table-Is-it-a-Good-Idea/m-p/725425#M1071163 cristian_av 2014-08-21T21:35:02Z Re: Replace Field Values with Hash in Fact Table.. ¿Is it a Good Idea? https://community.qlik.com/t5/QlikView/Replace-Field-Values-with-Hash-in-Fact-Table-Is-it-a-Good-Idea/m-p/725426#M1071164 <HTML><HEAD></HEAD><BODY><P>Or is it better to use the "Text" value instead a Hash?</P><P>Or is any other way to do that?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 22 Aug 2014 16:04:19 GMT https://community.qlik.com/t5/QlikView/Replace-Field-Values-with-Hash-in-Fact-Table-Is-it-a-Good-Idea/m-p/725426#M1071164 cristian_av 2014-08-22T16:04:19Z