Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello qv community,
my script looks like this:
------------------------------------------------------------------
1:
LOAD
RowNo() as Position_,
num(textbetween(@1,'<th rowspan="1" scope="row">','</th>')) as Jahr_
FROM
[Source]
2:
LOAD
RowNo()-1 as Position_,
textbetween(@1,'<td>','</td>') as Werte
FROM
[Source]
-------------------------------------------------------------------
Now I load a table with Position_, Jahr_, Werte in Qlikview
The Output looks like this:
Now I need all the year values to be filled up 5 rows upwards (for example:1997 also in Position_ :588-592
1996 also in Position_ :596-600)
Can somebody explain me how to setup the script?
Thx in advance for helping
You can play with Previous function to achieve your need.
You can play with Previous function to achieve your need.
Think that previous may not work, give it a try with the below
BaseTable:
LOAD ROWNO() AS Pos, * INLINE [Jahr, Werte
, 5
, 6
, 7
2010, 2
, 1
, 2
, 3
2011, 1];
Table:
NOCONCATENATE LOAD
Pos,
Werte,
IF(LEN(TRIM(Jahr)) = 0, PEEK('Jahr', -1), Jahr) AS Jahr
RESIDENT
BaseTable
ORDER BY
Pos DESC;
DROP TABLE BaseTable;
HTH Peter