topic script correction in Move to Qlik Cloud Analytics https://community.qlik.com/t5/Move-to-Qlik-Cloud-Analytics/script-correction/m-p/2463292#M1709 <P>Hi everybody&nbsp;<BR />I have 2 Table in Qlik Sense:&nbsp;</P> <P>PA</P> <P>Pernr&nbsp; &nbsp;BegDat0&nbsp; &nbsp; &nbsp; &nbsp;EndDat0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A</P> <P>760&nbsp; &nbsp; &nbsp;01.01.1960&nbsp; &nbsp; 15.01.2020&nbsp; &nbsp; &nbsp; &nbsp;2</P> <P>760&nbsp; &nbsp; &nbsp;16.01.2020&nbsp; &nbsp; 11.06.2024&nbsp; &nbsp; &nbsp; &nbsp;3</P> <P>571&nbsp; &nbsp; &nbsp; 01.01.1998&nbsp; &nbsp; 15.03.2012&nbsp; &nbsp; &nbsp; 2</P> <P>571&nbsp; &nbsp; &nbsp;16.03.2012&nbsp; &nbsp; &nbsp;10.05.2020&nbsp; &nbsp; &nbsp; 3</P> <P>571&nbsp; &nbsp; &nbsp;11.05.2020&nbsp; &nbsp; &nbsp; 31.12.2023&nbsp; &nbsp; &nbsp;4</P> <P>571&nbsp; &nbsp; &nbsp;01.01.2024&nbsp; &nbsp; &nbsp;11.06.2024&nbsp; &nbsp; &nbsp; 2</P> <P>And</P> <P>PB</P> <P>Pernr&nbsp; &nbsp; &nbsp;BegDat1&nbsp; &nbsp; &nbsp; &nbsp;EndDat1&nbsp; &nbsp; &nbsp; &nbsp; B</P> <P>760&nbsp; &nbsp; &nbsp; 01.01.1960&nbsp; &nbsp; 31.12.2023&nbsp; &nbsp;2300</P> <P>760&nbsp; &nbsp; &nbsp; 01.01.2024&nbsp; &nbsp; 15.01.2024&nbsp; &nbsp;2200</P> <P>760&nbsp; &nbsp; &nbsp; 16.01.2024&nbsp; &nbsp; 11.06.2024&nbsp; &nbsp;2500</P> <P>571&nbsp; &nbsp; &nbsp; 01.01.1998&nbsp; &nbsp; 15.12.2020&nbsp; &nbsp;2200</P> <P>571&nbsp; &nbsp; &nbsp; 16.12.2020&nbsp; &nbsp; 15.08.2022&nbsp; &nbsp;2500</P> <P>571&nbsp; &nbsp; &nbsp; 16.08.2022&nbsp; &nbsp; 01.12.2022&nbsp; &nbsp;2100</P> <P>571&nbsp; &nbsp; &nbsp; 02.12.2022&nbsp; &nbsp; 15.06.2023&nbsp; &nbsp;2500</P> <P>571&nbsp; &nbsp; &nbsp; 16.06.2023&nbsp; &nbsp; 31.12.2023&nbsp; &nbsp;2300</P> <P>571&nbsp; &nbsp; &nbsp; 01.01.2024&nbsp; &nbsp; 11.06.2024&nbsp; &nbsp;2200</P> <P>I want to join both of them and also time interval must be not repeated and at the end I want to have some table like:<BR />Pernr BegDat&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EndDat&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A<BR />760&nbsp; 01.01.1960&nbsp; &nbsp;15.01.2020&nbsp; &nbsp; 2300&nbsp; &nbsp; &nbsp; 02<BR />760&nbsp; 16.01.2020&nbsp; &nbsp; 31.12.2023&nbsp; &nbsp;2300&nbsp; &nbsp; &nbsp; 03<BR />760&nbsp; 01.01.2024&nbsp; &nbsp; 15.01.2024&nbsp; &nbsp;2200&nbsp; &nbsp; &nbsp; 03<BR />760 16.01.2024&nbsp; &nbsp; &nbsp;11.06.2024&nbsp; &nbsp;2500&nbsp; &nbsp; &nbsp; 03<BR />571&nbsp; 01.01.1998&nbsp; &nbsp; 15.03.2012&nbsp; &nbsp;2200&nbsp; &nbsp; &nbsp; 02<BR />571 16.03.2012&nbsp; &nbsp; &nbsp;10.05.2020&nbsp; &nbsp;2200&nbsp; &nbsp; &nbsp; 03<BR />571 11.05.2020&nbsp; &nbsp; &nbsp;15.12.2020&nbsp; &nbsp;2200&nbsp; &nbsp; &nbsp; 04<BR />571 16.12.2020&nbsp; &nbsp; &nbsp;15.08.2022&nbsp; &nbsp;2500&nbsp; &nbsp; &nbsp; 04<BR />571 16.08.2022&nbsp; &nbsp; &nbsp;01.12.2022&nbsp; &nbsp;2100&nbsp; &nbsp; &nbsp; 04<BR />571 02.12.2022&nbsp; &nbsp; &nbsp;15.06.2023&nbsp; &nbsp;2500&nbsp; &nbsp; &nbsp; 04<BR />571 16.06.2023&nbsp; &nbsp; &nbsp;31.12.2023&nbsp; &nbsp;2300&nbsp; &nbsp; &nbsp; 04<BR />571 01.01.2024&nbsp; &nbsp; &nbsp;11.06.2024&nbsp; &nbsp;2200&nbsp; &nbsp; &nbsp; 02<BR />I couldnt write very good script in data model.&nbsp;<BR />who can&nbsp; write something for me?<BR />many thanks&nbsp;</P> Tue, 27 Jan 2026 10:45:26 GMT faza 2026-01-27T10:45:26Z script correction https://community.qlik.com/t5/Move-to-Qlik-Cloud-Analytics/script-correction/m-p/2463292#M1709 <P>Hi everybody&nbsp;<BR />I have 2 Table in Qlik Sense:&nbsp;</P> <P>PA</P> <P>Pernr&nbsp; &nbsp;BegDat0&nbsp; &nbsp; &nbsp; &nbsp;EndDat0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A</P> <P>760&nbsp; &nbsp; &nbsp;01.01.1960&nbsp; &nbsp; 15.01.2020&nbsp; &nbsp; &nbsp; &nbsp;2</P> <P>760&nbsp; &nbsp; &nbsp;16.01.2020&nbsp; &nbsp; 11.06.2024&nbsp; &nbsp; &nbsp; &nbsp;3</P> <P>571&nbsp; &nbsp; &nbsp; 01.01.1998&nbsp; &nbsp; 15.03.2012&nbsp; &nbsp; &nbsp; 2</P> <P>571&nbsp; &nbsp; &nbsp;16.03.2012&nbsp; &nbsp; &nbsp;10.05.2020&nbsp; &nbsp; &nbsp; 3</P> <P>571&nbsp; &nbsp; &nbsp;11.05.2020&nbsp; &nbsp; &nbsp; 31.12.2023&nbsp; &nbsp; &nbsp;4</P> <P>571&nbsp; &nbsp; &nbsp;01.01.2024&nbsp; &nbsp; &nbsp;11.06.2024&nbsp; &nbsp; &nbsp; 2</P> <P>And</P> <P>PB</P> <P>Pernr&nbsp; &nbsp; &nbsp;BegDat1&nbsp; &nbsp; &nbsp; &nbsp;EndDat1&nbsp; &nbsp; &nbsp; &nbsp; B</P> <P>760&nbsp; &nbsp; &nbsp; 01.01.1960&nbsp; &nbsp; 31.12.2023&nbsp; &nbsp;2300</P> <P>760&nbsp; &nbsp; &nbsp; 01.01.2024&nbsp; &nbsp; 15.01.2024&nbsp; &nbsp;2200</P> <P>760&nbsp; &nbsp; &nbsp; 16.01.2024&nbsp; &nbsp; 11.06.2024&nbsp; &nbsp;2500</P> <P>571&nbsp; &nbsp; &nbsp; 01.01.1998&nbsp; &nbsp; 15.12.2020&nbsp; &nbsp;2200</P> <P>571&nbsp; &nbsp; &nbsp; 16.12.2020&nbsp; &nbsp; 15.08.2022&nbsp; &nbsp;2500</P> <P>571&nbsp; &nbsp; &nbsp; 16.08.2022&nbsp; &nbsp; 01.12.2022&nbsp; &nbsp;2100</P> <P>571&nbsp; &nbsp; &nbsp; 02.12.2022&nbsp; &nbsp; 15.06.2023&nbsp; &nbsp;2500</P> <P>571&nbsp; &nbsp; &nbsp; 16.06.2023&nbsp; &nbsp; 31.12.2023&nbsp; &nbsp;2300</P> <P>571&nbsp; &nbsp; &nbsp; 01.01.2024&nbsp; &nbsp; 11.06.2024&nbsp; &nbsp;2200</P> <P>I want to join both of them and also time interval must be not repeated and at the end I want to have some table like:<BR />Pernr BegDat&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;EndDat&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A<BR />760&nbsp; 01.01.1960&nbsp; &nbsp;15.01.2020&nbsp; &nbsp; 2300&nbsp; &nbsp; &nbsp; 02<BR />760&nbsp; 16.01.2020&nbsp; &nbsp; 31.12.2023&nbsp; &nbsp;2300&nbsp; &nbsp; &nbsp; 03<BR />760&nbsp; 01.01.2024&nbsp; &nbsp; 15.01.2024&nbsp; &nbsp;2200&nbsp; &nbsp; &nbsp; 03<BR />760 16.01.2024&nbsp; &nbsp; &nbsp;11.06.2024&nbsp; &nbsp;2500&nbsp; &nbsp; &nbsp; 03<BR />571&nbsp; 01.01.1998&nbsp; &nbsp; 15.03.2012&nbsp; &nbsp;2200&nbsp; &nbsp; &nbsp; 02<BR />571 16.03.2012&nbsp; &nbsp; &nbsp;10.05.2020&nbsp; &nbsp;2200&nbsp; &nbsp; &nbsp; 03<BR />571 11.05.2020&nbsp; &nbsp; &nbsp;15.12.2020&nbsp; &nbsp;2200&nbsp; &nbsp; &nbsp; 04<BR />571 16.12.2020&nbsp; &nbsp; &nbsp;15.08.2022&nbsp; &nbsp;2500&nbsp; &nbsp; &nbsp; 04<BR />571 16.08.2022&nbsp; &nbsp; &nbsp;01.12.2022&nbsp; &nbsp;2100&nbsp; &nbsp; &nbsp; 04<BR />571 02.12.2022&nbsp; &nbsp; &nbsp;15.06.2023&nbsp; &nbsp;2500&nbsp; &nbsp; &nbsp; 04<BR />571 16.06.2023&nbsp; &nbsp; &nbsp;31.12.2023&nbsp; &nbsp;2300&nbsp; &nbsp; &nbsp; 04<BR />571 01.01.2024&nbsp; &nbsp; &nbsp;11.06.2024&nbsp; &nbsp;2200&nbsp; &nbsp; &nbsp; 02<BR />I couldnt write very good script in data model.&nbsp;<BR />who can&nbsp; write something for me?<BR />many thanks&nbsp;</P> Tue, 27 Jan 2026 10:45:26 GMT https://community.qlik.com/t5/Move-to-Qlik-Cloud-Analytics/script-correction/m-p/2463292#M1709 faza 2026-01-27T10:45:26Z