topic Join three tables with different fields in QlikView https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765067#M663746 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I'm new with Qlikview and don't know how to go on now.</P><P></P><P>I got three tables:</P><P></P><P>KST:</P><P>CostCenterNumber</P><P>CostCenterDescription</P><P></P><P>DATA:</P><P>CostCenterDescription</P><P>Value1</P><P>Value2</P><P></P><P>WorkedHours:</P><P>CostCenterNumber</P><P>HoursWorked</P><P></P><P>I need to link DATA (includes sales etc.) with WorkedHours to now how many hours used for made sales. Problem is, that I got CostCenterNumber in the WorkedHours and CostCenterDescription in the Data, the translation is in KST. </P><P>How do I have to script that? </P><P>The three tables come from Excel.</P><P></P><P>Many thanks for your help in advance!</P><P>Christoph</P></BODY></HTML> Fri, 09 Jan 2015 15:34:53 GMT 2015-01-09T15:34:53Z Join three tables with different fields https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765067#M663746 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I'm new with Qlikview and don't know how to go on now.</P><P></P><P>I got three tables:</P><P></P><P>KST:</P><P>CostCenterNumber</P><P>CostCenterDescription</P><P></P><P>DATA:</P><P>CostCenterDescription</P><P>Value1</P><P>Value2</P><P></P><P>WorkedHours:</P><P>CostCenterNumber</P><P>HoursWorked</P><P></P><P>I need to link DATA (includes sales etc.) with WorkedHours to now how many hours used for made sales. Problem is, that I got CostCenterNumber in the WorkedHours and CostCenterDescription in the Data, the translation is in KST. </P><P>How do I have to script that? </P><P>The three tables come from Excel.</P><P></P><P>Many thanks for your help in advance!</P><P>Christoph</P></BODY></HTML> Fri, 09 Jan 2015 15:34:53 GMT https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765067#M663746 2015-01-09T15:34:53Z Re: Join three tables with different fields https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765068#M663747 <HTML><HEAD></HEAD><BODY><P>Load * From KST;</P><P>left join</P><P>load * from DATA;</P><P>left join</P><P>load * from WorkedHours;</P><P></P><P>replace the load * .... with the loading from Excel.</P><P></P><P>Let me know</P></BODY></HTML> Fri, 09 Jan 2015 15:43:09 GMT https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765068#M663747 alexandros17 2015-01-09T15:43:09Z Re: Join three tables with different fields https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765069#M663748 <HTML><HEAD></HEAD><BODY><P>No that doesn't lead to correct results.</P><P>Another problem I have forgotten to tell is that I got more CostCenters in "WorkedHours" than in "Data", of course I need to keep them.</P></BODY></HTML> Fri, 09 Jan 2015 15:55:50 GMT https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765069#M663748 2015-01-09T15:55:50Z Re: Join three tables with different fields https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765070#M663749 <HTML><HEAD></HEAD><BODY><P>So try with</P><P></P><P>Load * From KST;</P><P>left join</P><P>load * from DATA;</P><P>join</P><P>load * from WorkedHours;</P></BODY></HTML> Fri, 09 Jan 2015 15:58:18 GMT https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765070#M663749 alexandros17 2015-01-09T15:58:18Z Re: Join three tables with different fields https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765071#M663750 <HTML><HEAD></HEAD><BODY><P>Now I got the correct summaration of hours but no values from the DATA table, its all gone. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Fri, 09 Jan 2015 16:04:52 GMT https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765071#M663750 2015-01-09T16:04:52Z Re: Join three tables with different fields https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765072#M663751 <HTML><HEAD></HEAD><BODY><P>to be sure not to exclude any value you can use Always join:</P><P></P><P>Load * From KST;</P><P>join</P><P>load * from DATA;</P><P>join</P><P>load * from WorkedHours;</P><P></P><P>But I think that the problem comes from different CostCenterDescription,</P><P>try, when you load the 2 tables with the field CostCenterDescription to:</P><P></P><P>Load</P><P>...</P><P>Upper(Trim(CostCenterDescription)) as CostCenterDescription</P><P>...</P></BODY></HTML> Fri, 09 Jan 2015 16:13:54 GMT https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765072#M663751 alexandros17 2015-01-09T16:13:54Z Re: Join three tables with different fields https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765073#M663752 <HTML><HEAD></HEAD><BODY><P>Wow! That seems to be the solution, great! Thanks a lot. I will have a few more checks now.</P><P></P><P>Have a nice weekend so far <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Fri, 09 Jan 2015 16:17:20 GMT https://community.qlik.com/t5/QlikView/Join-three-tables-with-different-fields/m-p/765073#M663752 2015-01-09T16:17:20Z