topic Generate fields between 2 numbers in QlikView

Generate fields between 2 numbers

villafuerte — Thu, 16 Dec 2010 20:39:06 GMT

Hi,

I'm trying to create new fields from start and end values in a table. All the values I need are there, so I'm not shure if Interval Match is the solution. It's something like this:

Start End Quota

1 3 555

4 7 888

8 9 333

And I want to create something like this:

Time Quota

1 555

2 555

3 555

4 888

5 888

6 888

7 888

8 333

9 333

Thanks

Generate fields between 2 numbers

Thu, 16 Dec 2010 21:32:23 GMT

Did you try with the subfield function ?

Subfield can duplicate records but I'have not tested your very interesting issue.

Generate fields between 2 numbers

pover — Thu, 16 Dec 2010 21:36:20 GMT

Villafuerte,

Do something like this:

Original_Table:
LOAD * INLINE [
Start,End,Quota
1,3,555,
4,7,888
8,9,333
];

Table:
Load iterno() as Iterno,
Start + iterno()-1 as Time,
Quota
resident Original_Table
while iterno() <= End-Start+1;

Drop table Original_Table;

Regards.

Generate fields between 2 numbers

villafuerte — Thu, 16 Dec 2010 21:58:50 GMT

Thanks Karl!