topic Create a table from another in QlikView

Create a table from another

ecabanas — Tue, 20 Sep 2016 10:08:19 GMT

Hi all,

I'm in a trouble. I have a table like this:

I would like to create a table For every month an ID ItemId+Date like this:

Many many thank's again

Eduard

sunny_talwar — Tue, 20 Sep 2016 10:16:33 GMT

May be like this:

Table:

LOAD *,

Date(Floor(MonthEnd(From, IterNo() - 1))) as Date,

ItemId & '-' & Floor(MonthEnd(From, IterNo() - 1)) as ID

While Floor(MonthEnd(From, IterNo() - 1)) <= To;

LOAD * INLINE [

ItemId, From, To, Tarifa

10357856, 01/02/2016, 29/02/2016, "0,88"

10357856, 01/03/2016, 31/12/2016, "0,52"

];

Gysbert_Wassenaar — Tue, 20 Sep 2016 10:19:20 GMT

NewTable:

LOAD

Date(MonthStart(From,IterNo())-1) as Date,

ItemId & '-' & num(MonthStart(From,IterNo())-1) as ID,

Price

FROM

...source_table

WHILE

MonthStart(From,IterNo())-1 < To

;

If From and To are strings instead of date then first use the date# function on them to turn the strings into dates:

date#(From, 'DD/MM/YYYY')

date#(To, 'DD/MM/YYYY')

ecabanas — Tue, 20 Sep 2016 13:43:56 GMT

Great Sunny as always!!!

Thank you