https://community.qlik.com/t5/QlikView/How-do-I-combine-tables/m-p/2031865#M1222623 <P>I have 3 tables of fetched data.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_0-1675138833512.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99207i325DD33F11A24D28/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_0-1675138833512.png" alt="Paknanarn23_0-1675138833512.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_1-1675138862640.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99208iCAB4A1DC88577F4B/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_1-1675138862640.png" alt="Paknanarn23_1-1675138862640.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_2-1675138877112.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99209iC15E6B21F474AEC5/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_2-1675138877112.png" alt="Paknanarn23_2-1675138877112.png" /></span></P> <P>&nbsp;</P> <P>I want these 3 tables to be joined using this code as joins.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_3-1675138920415.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99210i36247FF3EC81A526/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_3-1675138920415.png" alt="Paknanarn23_3-1675138920415.png" /></span></P> <P><BR />I've tried renaming the fields in the other 2 tables to be the same as the first one. but it was not successful What should I do?</P> Fri, 15 Nov 2024 21:50:52 GMT Paknanarn23 2024-11-15T21:50:52Z https://community.qlik.com/t5/QlikView/How-do-I-combine-tables/m-p/2031865#M1222623 <P>I have 3 tables of fetched data.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_0-1675138833512.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99207i325DD33F11A24D28/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_0-1675138833512.png" alt="Paknanarn23_0-1675138833512.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_1-1675138862640.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99208iCAB4A1DC88577F4B/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_1-1675138862640.png" alt="Paknanarn23_1-1675138862640.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_2-1675138877112.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99209iC15E6B21F474AEC5/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_2-1675138877112.png" alt="Paknanarn23_2-1675138877112.png" /></span></P> <P>&nbsp;</P> <P>I want these 3 tables to be joined using this code as joins.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_3-1675138920415.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99210i36247FF3EC81A526/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_3-1675138920415.png" alt="Paknanarn23_3-1675138920415.png" /></span></P> <P><BR />I've tried renaming the fields in the other 2 tables to be the same as the first one. but it was not successful What should I do?</P> Fri, 15 Nov 2024 21:50:52 GMT https://community.qlik.com/t5/QlikView/How-do-I-combine-tables/m-p/2031865#M1222623 Paknanarn23 2024-11-15T21:50:52Z https://community.qlik.com/t5/QlikView/How-do-I-combine-tables/m-p/2032274#M1222624 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/186483">@Paknanarn23</a>,</P> <P>The QlikView Help entry&nbsp;<A href="https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/combine-tables-with-join-keep.htm#" target="_self"><STRONG>Combining tables with Join and</STRONG> <STRONG>Keep</STRONG></A> should&nbsp;point you in the correct direction.</P> <P>Best Regards</P> Tue, 31 Jan 2023 15:17:07 GMT https://community.qlik.com/t5/QlikView/How-do-I-combine-tables/m-p/2032274#M1222624 Chip_Matejowsky 2023-01-31T15:17:07Z https://community.qlik.com/t5/QlikView/How-do-I-combine-tables/m-p/2032529#M1222625 <P>I want 3 tables of data to be linked&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_0-1675215908905.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99374i001D1DC407DC76A0/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_0-1675215908905.png" alt="Paknanarn23_0-1675215908905.png" /></span></P> <P>using the field of the first table named field Output is concatenated to Busser_Shift and Buffer_ShiftMAOI.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_1-1675216297877.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99375i39E94E4C6C8A41DE/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_1-1675216297877.png" alt="Paknanarn23_1-1675216297877.png" /></span></P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Paknanarn23_2-1675216320301.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99376iC8D47E31DCBEB1F0/image-size/medium?v=v2&amp;px=400" role="button" title="Paknanarn23_2-1675216320301.png" alt="Paknanarn23_2-1675216320301.png" /></span></P> <P>&nbsp;</P> Wed, 01 Feb 2023 01:52:07 GMT https://community.qlik.com/t5/QlikView/How-do-I-combine-tables/m-p/2032529#M1222625 Paknanarn23 2023-02-01T01:52:07Z