topic Re: Creating Additional Records based on a loaded table in Connectivity & Data Prep

Creating Additional Records based on a loaded table

Irisha55ets — Thu, 07 Jul 2022 14:40:55 GMT

Hello Experts,

I have a table of quarterly sales data. I am trying to generate additional rows for multiple quarters into the future.

Sample existing records:

03/31/2021	100
06/30/2021	105
09/30/2021	109
12/31/2021	112

03/31/2022	115
06/30/2022	120

How can I use the load script to create estimated future records? (without using an inline load)

Thank you!

Re: Creating Additional Records based on a loaded table

rwunderlich — Thu, 07 Jul 2022 16:49:20 GMT

Assuming existing column names of "Quarter" and "Value", how about:

Concatenate (BaseTable)
LOAD
Date(AddMonths(MaxQuarter, IterNo()*3)) as Quarter,
0 as Value
While IterNo() <= 4 // Add 4 more Quarters
;
LOAD
Max(Quarter) as MaxQuarter
Resident BaseTable;

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Creating Additional Records based on a loaded table

Irisha55ets — Fri, 08 Jul 2022 12:39:46 GMT

It is an honor to receive an assist from the man in the white hat.

Very much appreciate the help, Rob!