https://community.qlik.com/t5/QlikView/JOINS-ROW-NO/m-p/1738853#M452823 <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187</A></P><P><A href="https://community.qlik.com/t5/QlikView-Documents/IntervalMatch-and-Slowly-Changing-Dimensions/ta-p/1479928" target="_blank">https://community.qlik.com/t5/QlikView-Documents/IntervalMatch-and-Slowly-Changing-Dimensions/ta-p/1479928</A></P><P>&nbsp;</P> Wed, 26 Aug 2020 13:46:19 GMT Or 2020-08-26T13:46:19Z https://community.qlik.com/t5/QlikView/JOINS-ROW-NO/m-p/1738830#M452821 <P>Hello,</P><P>&nbsp;</P><P>I have Data</P><TABLE width="430"><TBODY><TR><TD width="132">order</TD><TD width="106">item</TD><TD width="64">sno</TD><TD width="64">from</TD><TD width="64">to</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0001</TD><TD>27-12-2019</TD><TD>02-01-2020</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0002</TD><TD>15-01-2020</TD><TD>15-01-2020</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0003</TD><TD>16-01-2020</TD><TD>16-01-2020</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0004</TD><TD>19-02-2020</TD><TD>19-02-2020</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Here Im Passing Order and Item and getting</P><TABLE width="116"><TBODY><TR><TD width="116">0030000820|000010</TD></TR><TR><TD>0030000825|000010</TD></TR></TBODY></TABLE><P>below items</P><P>I just Join Table</P><P>Here Im Getting 8 Items Because 2*4</P><TABLE width="494"><TBODY><TR><TD width="132">0140000209</TD><TD width="106">000010</TD><TD width="64">0001</TD><TD width="64">27-12-2019</TD><TD width="64">02-01-2020</TD><TD width="64">0030000820|000010|</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0002</TD><TD>15-01-2020</TD><TD>15-01-2020</TD><TD>0030000820|000010|</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0003</TD><TD>16-01-2020</TD><TD>16-01-2020</TD><TD>0030000820|000010|</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0004</TD><TD>19-02-2020</TD><TD>19-02-2020</TD><TD>0030000820|000010|</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0001</TD><TD>27-12-2019</TD><TD>02-01-2020</TD><TD>0030000825|000010|</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0002</TD><TD>15-01-2020</TD><TD>15-01-2020</TD><TD>0030000825|000010|</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0003</TD><TD>16-01-2020</TD><TD>16-01-2020</TD><TD>0030000825|000010|</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0004</TD><TD>19-02-2020</TD><TD>19-02-2020</TD><TD>0030000825|000010|</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>and in 2nd table also have from and to Date</P><TABLE width="244"><TBODY><TR><TD width="116">&nbsp;</TD><TD width="64">from</TD><TD width="64">to</TD></TR><TR><TD>0030000820|000010</TD><TD>27-12-2019</TD><TD>02-01-2020</TD></TR><TR><TD>0030000825|000010</TD><TD>16-01-2020</TD><TD>16-01-2020</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I'm Expecting Output&nbsp;</P><TABLE width="637"><TBODY><TR><TD width="132">order</TD><TD width="106">item</TD><TD width="64">sno</TD><TD width="64">from</TD><TD width="64">to</TD><TD width="207">&nbsp;</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0001</TD><TD>27-12-2019</TD><TD>02-01-2020</TD><TD>0030000820|000010|</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0002</TD><TD>15-01-2020</TD><TD>15-01-2020</TD><TD>&nbsp;</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0003</TD><TD>16-01-2020</TD><TD>16-01-2020</TD><TD>0030000825|000010|</TD></TR><TR><TD>0140000209</TD><TD>000010</TD><TD>0004</TD><TD>19-02-2020</TD><TD>19-02-2020</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can I Archive This</P> Sat, 16 Nov 2024 18:11:12 GMT https://community.qlik.com/t5/QlikView/JOINS-ROW-NO/m-p/1738830#M452821 Surya 2024-11-16T18:11:12Z https://community.qlik.com/t5/QlikView/JOINS-ROW-NO/m-p/1738853#M452823 <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187</A></P><P><A href="https://community.qlik.com/t5/QlikView-Documents/IntervalMatch-and-Slowly-Changing-Dimensions/ta-p/1479928" target="_blank">https://community.qlik.com/t5/QlikView-Documents/IntervalMatch-and-Slowly-Changing-Dimensions/ta-p/1479928</A></P><P>&nbsp;</P> Wed, 26 Aug 2020 13:46:19 GMT https://community.qlik.com/t5/QlikView/JOINS-ROW-NO/m-p/1738853#M452823 Or 2020-08-26T13:46:19Z