topic Re: Data Modeling Struggles - Synthetic Keys/Table in QlikView https://community.qlik.com/t5/QlikView/Data-Modeling-Struggles-Synthetic-Keys-Table/m-p/1691079#M726848 <P>how about using concatenate</P> Mon, 06 Apr 2020 05:33:29 GMT anushree1 2020-04-06T05:33:29Z Data Modeling Struggles - Synthetic Keys/Table https://community.qlik.com/t5/QlikView/Data-Modeling-Struggles-Synthetic-Keys-Table/m-p/1691074#M726847 <P>I have 2 tables which have a number of similar field names. I am aware that renaming/removing the similar field names can remove synthetic keys but the expected output requires that I keep the fields. I have been toying around with QUALIFY but there are just so many similar fields that I am not sure if my intuition to rename all of the fields are correct. My hope is that there is another option that I have overlooked for the data modeling that can help remove the synthetic keys/table.&nbsp;</P><P>How would you approach this? Below is an example of the data that I am working with.&nbsp;</P><TABLE width="533"><TBODY><TR><TD width="533">Table 1</TD></TR><TR><TD>Company</TD><TD>First Name</TD><TD>Last Name</TD><TD>EmployeeStatus</TD><TD>Pay</TD><TD>City</TD><TD>State</TD><TD>Country</TD></TR><TR><TD>McDonalds</TD><TD>Joe</TD><TD>Smith</TD><TD>Permanent</TD><TD>Hourly</TD><TD>New York</TD><TD>NY</TD><TD>USA</TD></TR><TR><TD>Burger King</TD><TD>Amy</TD><TD>Doe</TD><TD>Permanent</TD><TD>Hourly</TD><TD>Chicago</TD><TD>IL</TD><TD>USA</TD></TR><TR><TD>In &amp; Out</TD><TD>Tim</TD><TD>Moe</TD><TD>Permanent</TD><TD>Salary</TD><TD>Las Vegas</TD><TD>NV</TD><TD>USA</TD></TR><TR><TD>Shake Shack</TD><TD>Nancy</TD><TD>Drew</TD><TD>Permanent</TD><TD>Salary</TD><TD>Miami</TD><TD>FL</TD><TD>USA</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE width="533"><TBODY><TR><TD width="533">Table 2</TD></TR><TR><TD>Company</TD><TD>First Name</TD><TD>Last Name</TD><TD>EmployeeStatus</TD><TD>City</TD><TD>State</TD><TD>Country</TD></TR><TR><TD>Chick-Fil-A</TD><TD>Steve</TD><TD>Doll</TD><TD>Temp</TD><TD>Dallas</TD><TD>TX</TD><TD>USA</TD><TD>&nbsp;</TD></TR><TR><TD>Popeyes</TD><TD>Mary</TD><TD>Stevens</TD><TD>Temp</TD><TD>Seattle</TD><TD>WA</TD><TD>USA</TD><TD>&nbsp;</TD></TR><TR><TD>Pizza Hut</TD><TD>Mickey</TD><TD>Mouse</TD><TD>Temp</TD><TD>San Diego</TD><TD>CA</TD><TD>USA</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE width="533"><TBODY><TR><TD width="533">Expected Output</TD></TR><TR><TD>Company</TD><TD>First Name</TD><TD>Last Name</TD><TD>EmployeeStatus</TD><TD>Pay</TD><TD>City</TD><TD>State</TD><TD>Country</TD></TR><TR><TD>McDonalds</TD><TD>Joe</TD><TD>Smith</TD><TD>Permanent</TD><TD>Hourly</TD><TD>New York</TD><TD>NY</TD><TD>USA</TD></TR><TR><TD>Burger King</TD><TD>Amy</TD><TD>Doe</TD><TD>Permanent</TD><TD>Hourly</TD><TD>Chicago</TD><TD>IL</TD><TD>USA</TD></TR><TR><TD>In &amp; Out</TD><TD>Tim</TD><TD>Moe</TD><TD>Permanent</TD><TD>Salary</TD><TD>Las Vegas</TD><TD>NV</TD><TD>USA</TD></TR><TR><TD>Shake Shack</TD><TD>Nancy</TD><TD>Drew</TD><TD>Permanent</TD><TD>Salary</TD><TD>Miami</TD><TD>FL</TD><TD>USA</TD></TR><TR><TD>Chick-Fil-A</TD><TD>Steve</TD><TD>Doll</TD><TD>Temp</TD><TD>&nbsp;</TD><TD>Dallas</TD><TD>TX</TD><TD>USA</TD></TR><TR><TD>Popeyes</TD><TD>Mary</TD><TD>Stevens</TD><TD>Temp</TD><TD>&nbsp;</TD><TD>Seattle</TD><TD>WA</TD><TD>USA</TD></TR><TR><TD>Pizza Hut</TD><TD>Mickey</TD><TD>Mouse</TD><TD>Temp</TD><TD>&nbsp;</TD><TD>San Diego</TD><TD>CA</TD><TD>USA</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 18:49:57 GMT https://community.qlik.com/t5/QlikView/Data-Modeling-Struggles-Synthetic-Keys-Table/m-p/1691074#M726847 win_anthony 2024-11-16T18:49:57Z Re: Data Modeling Struggles - Synthetic Keys/Table https://community.qlik.com/t5/QlikView/Data-Modeling-Struggles-Synthetic-Keys-Table/m-p/1691079#M726848 <P>how about using concatenate</P> Mon, 06 Apr 2020 05:33:29 GMT https://community.qlik.com/t5/QlikView/Data-Modeling-Struggles-Synthetic-Keys-Table/m-p/1691079#M726848 anushree1 2020-04-06T05:33:29Z Re: Data Modeling Struggles - Synthetic Keys/Table https://community.qlik.com/t5/QlikView/Data-Modeling-Struggles-Synthetic-Keys-Table/m-p/1691304#M726849 <P>It took a little while to figure out how to structure CONCATENATE but that was exactly what I needed.&nbsp;</P><P>Thanks!</P> Mon, 06 Apr 2020 15:55:22 GMT https://community.qlik.com/t5/QlikView/Data-Modeling-Struggles-Synthetic-Keys-Table/m-p/1691304#M726849 win_anthony 2020-04-06T15:55:22Z Re: Data Modeling Struggles - Synthetic Keys/Table https://community.qlik.com/t5/QlikView/Data-Modeling-Struggles-Synthetic-Keys-Table/m-p/1697735#M726850 <P>The following Help link may be of use to others that come to this post as well:</P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/LoadData/best-practices-data-modeling.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/LoadData/best-practices-data-modeling.htm</A></P><P>Regards,<BR />Brett</P> Wed, 29 Apr 2020 13:39:28 GMT https://community.qlik.com/t5/QlikView/Data-Modeling-Struggles-Synthetic-Keys-Table/m-p/1697735#M726850 Brett_Bleess 2020-04-29T13:39:28Z