topic Multiple keys for one dimension in QlikView https://community.qlik.com/t5/QlikView/Multiple-keys-for-one-dimension/m-p/1622088#M445853 <P>I have a few fact tables that I have concatenated.&nbsp; In these tables I have multiple WIDs that join to a single dimension.&nbsp; I was wondering what would be the best way to handle this situation.&nbsp;</P><TABLE><TBODY><TR><TD>Table_Name</TD><TD>Column_Name</TD><TD>Condition</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>BUSINESS_UNIT_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>BUSINESS_UNIT_PO_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>BUSINESS_UNIT_GL_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>BUSINESS_UNIT_PC_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>OPERATING_UNIT_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>PURCH_DEPT_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_ACCOUNT_WID</TD><TD>&nbsp;W_GL_ACCOUNT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>PROJECT_WID</TD><TD>W_PROJECT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>PURCH_LEGDER_WID</TD><TD>W_LEDGER_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>PURCH_SUPPLIER_WID</TD><TD>W_PARTY_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>OPERATOR_WID</TD><TD>WC_OPERATOR_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>RECEIVED_ON_DT_WID</TD><TD>AHS_DW.W_DAY_D&nbsp; using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>JOURNAL_DT_WID</TD><TD>AHS_DW.W_DAY_D&nbsp; using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>ACCOUNTING_DT_WID</TD><TD>AHS_DW.W_DAY_D&nbsp; using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>PURCH_ACCOUNTING_PERIOD_WID</TD><TD>W_MCAL_PERIOD_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT1_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT2_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT3_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT4_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT5_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT6_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT7_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT8_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT9_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT10_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P> Tue, 10 Sep 2019 12:42:40 GMT justcotto 2019-09-10T12:42:40Z Multiple keys for one dimension https://community.qlik.com/t5/QlikView/Multiple-keys-for-one-dimension/m-p/1622088#M445853 <P>I have a few fact tables that I have concatenated.&nbsp; In these tables I have multiple WIDs that join to a single dimension.&nbsp; I was wondering what would be the best way to handle this situation.&nbsp;</P><TABLE><TBODY><TR><TD>Table_Name</TD><TD>Column_Name</TD><TD>Condition</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>BUSINESS_UNIT_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>BUSINESS_UNIT_PO_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>BUSINESS_UNIT_GL_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>BUSINESS_UNIT_PC_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>OPERATING_UNIT_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>PURCH_DEPT_WID</TD><TD>&nbsp;W_INT_ORG_D using SCD1_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_ACCOUNT_WID</TD><TD>&nbsp;W_GL_ACCOUNT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>PROJECT_WID</TD><TD>W_PROJECT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>PURCH_LEGDER_WID</TD><TD>W_LEDGER_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>PURCH_SUPPLIER_WID</TD><TD>W_PARTY_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>OPERATOR_WID</TD><TD>WC_OPERATOR_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>RECEIVED_ON_DT_WID</TD><TD>AHS_DW.W_DAY_D&nbsp; using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>JOURNAL_DT_WID</TD><TD>AHS_DW.W_DAY_D&nbsp; using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>ACCOUNTING_DT_WID</TD><TD>AHS_DW.W_DAY_D&nbsp; using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>PURCH_ACCOUNTING_PERIOD_WID</TD><TD>W_MCAL_PERIOD_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT1_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT2_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT3_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT4_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT5_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT6_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT7_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT8_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT9_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR><TR><TD>WC_PURCH_RCPT_F</TD><TD>GL_SEGMENT10_WID</TD><TD>W_GL_SEGMENT_D using ROW_WID</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P> Tue, 10 Sep 2019 12:42:40 GMT https://community.qlik.com/t5/QlikView/Multiple-keys-for-one-dimension/m-p/1622088#M445853 justcotto 2019-09-10T12:42:40Z Re: Multiple keys for one dimension https://community.qlik.com/t5/QlikView/Multiple-keys-for-one-dimension/m-p/1622714#M445895 <P>Maybe a transforming per&nbsp;<A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083" target="_self">The-Crosstable-Load</A> would be useful.</P><P>- Marcus</P> Wed, 11 Sep 2019 15:19:37 GMT https://community.qlik.com/t5/QlikView/Multiple-keys-for-one-dimension/m-p/1622714#M445895 marcus_sommer 2019-09-11T15:19:37Z Re: Multiple keys for one dimension https://community.qlik.com/t5/QlikView/Multiple-keys-for-one-dimension/m-p/1627043#M446178 <P><SPAN>Justin, did Marcus' post help you with things, or are you still trying to figure things out?&nbsp; If Marcus' idea worked, please be sure to give him credit by using the Accept as Solution button on his post.&nbsp; If you are still trying to figure things out, please leave an update for us.</SPAN></P> <P><SPAN>Regards,<BR />Brett</SPAN></P> Mon, 23 Sep 2019 16:19:53 GMT https://community.qlik.com/t5/QlikView/Multiple-keys-for-one-dimension/m-p/1627043#M446178 Brett_Bleess 2019-09-23T16:19:53Z