https://community.qlik.com/t5/App-Development/Duplicates-from-linked-tables/m-p/1777611#M60333 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BonganiButh_0-1611728756485.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/47816i4A16F84DAA3704CC/image-size/medium?v=v2&amp;px=400" role="button" title="BonganiButh_0-1611728756485.png" alt="BonganiButh_0-1611728756485.png" /></span></P><P>&nbsp;</P><P>Hi Everyone.&nbsp;</P><P>I have joined my two tables as above on (demand_id). However I am getting duplicates as seen below.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BonganiButh_1-1611728921708.png" style="width: 812px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/47817i3B455680274C267D/image-dimensions/812x92?v=v2" width="812" height="92" role="button" title="BonganiButh_1-1611728921708.png" alt="BonganiButh_1-1611728921708.png" /></span></P><P>everything seems to be fine except on the 'Labor fields' which are created from two different tables. code is shared below from load script.</P><P>demand: Labour Start Datetime</P><P>TIMESTAMP(DATE(FLOOR([actual_dt])) + (TIME([actual_tm]) - TIME(FLOOR([actual_tm])))) AS actual_date_time</P><P>&nbsp;</P><P>and demand_labor: Labour End DateTime</P><P>TimeStamp(Date(Floor([arrive_dt])) + (Time([arrive_tm]) - Time(Floor([arrive_tm])))) AS arrive_date_time</P><P>&nbsp;</P><P>Any ideas on how I can approach this differently?</P> Wed, 27 Jan 2021 06:31:48 GMT BonganiButh 2021-01-27T06:31:48Z https://community.qlik.com/t5/App-Development/Duplicates-from-linked-tables/m-p/1777611#M60333 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BonganiButh_0-1611728756485.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/47816i4A16F84DAA3704CC/image-size/medium?v=v2&amp;px=400" role="button" title="BonganiButh_0-1611728756485.png" alt="BonganiButh_0-1611728756485.png" /></span></P><P>&nbsp;</P><P>Hi Everyone.&nbsp;</P><P>I have joined my two tables as above on (demand_id). However I am getting duplicates as seen below.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BonganiButh_1-1611728921708.png" style="width: 812px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/47817i3B455680274C267D/image-dimensions/812x92?v=v2" width="812" height="92" role="button" title="BonganiButh_1-1611728921708.png" alt="BonganiButh_1-1611728921708.png" /></span></P><P>everything seems to be fine except on the 'Labor fields' which are created from two different tables. code is shared below from load script.</P><P>demand: Labour Start Datetime</P><P>TIMESTAMP(DATE(FLOOR([actual_dt])) + (TIME([actual_tm]) - TIME(FLOOR([actual_tm])))) AS actual_date_time</P><P>&nbsp;</P><P>and demand_labor: Labour End DateTime</P><P>TimeStamp(Date(Floor([arrive_dt])) + (Time([arrive_tm]) - Time(Floor([arrive_tm])))) AS arrive_date_time</P><P>&nbsp;</P><P>Any ideas on how I can approach this differently?</P> Wed, 27 Jan 2021 06:31:48 GMT https://community.qlik.com/t5/App-Development/Duplicates-from-linked-tables/m-p/1777611#M60333 BonganiButh 2021-01-27T06:31:48Z