topic I have two sql tables one containing dimension and other expression in QlikView https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696414#M251586 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>How do I merge both table to ensure a smooth association of all my expression to my dimension. These is a key field from both table how do I resolve this?</P><P></P><P>Regards</P><P>Ema</P></BODY></HTML> Sat, 25 Oct 2014 14:47:49 GMT 2014-10-25T14:47:49Z I have two sql tables one containing dimension and other expression https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696414#M251586 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>How do I merge both table to ensure a smooth association of all my expression to my dimension. These is a key field from both table how do I resolve this?</P><P></P><P>Regards</P><P>Ema</P></BODY></HTML> Sat, 25 Oct 2014 14:47:49 GMT https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696414#M251586 2014-10-25T14:47:49Z Re: I have two sql tables one containing dimension and other expression https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696415#M251587 <HTML><HEAD></HEAD><BODY><P>I suppose you want to associate the tables by ProductKey only</P><P>Remove LastModified from the two SQL select in your script</P></BODY></HTML> Sat, 25 Oct 2014 16:30:33 GMT https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696415#M251587 maxgro 2014-10-25T16:30:33Z Re: I have two sql tables one containing dimension and other expression https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696416#M251588 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I want the products in dimension table to be associated with all the fields in expression table.</P><P></P><P>Rgds</P></BODY></HTML> Sat, 25 Oct 2014 16:42:11 GMT https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696416#M251588 2014-10-25T16:42:11Z Re: I have two sql tables one containing dimension and other expression https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696417#M251589 <HTML><HEAD></HEAD><BODY><P>Productkey seems like good enough key field between your fact table and dimension table and you dont want to have that "lastmodifed" column disrupting your data, rename them. table.field or however you like it.</P><P></P><P>Cheers!</P></BODY></HTML> Sat, 25 Oct 2014 16:57:31 GMT https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696417#M251589 2014-10-25T16:57:31Z Re: I have two sql tables one containing dimension and other expression https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696418#M251590 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello,</P> <P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I want the products in dimension table to be associated with all the fields in expression table.</P> <P></P> <P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Rgds</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>Well, they will. one unique key field between two tables is enough. If you think there should be more keys between two tables as per business logic concatenate them into one single key.</P></BODY></HTML> Sat, 25 Oct 2014 17:00:20 GMT https://community.qlik.com/t5/QlikView/I-have-two-sql-tables-one-containing-dimension-and-other/m-p/696418#M251590 2014-10-25T17:00:20Z