copy first value in lines above

[#1]

Hello,

Can anyone help me with a function in script which inputs in Load the Command value in each line?

For example, I have the command 420803 with 3 positions and I need to appear the command value in each line.

Same for command 420890 and other more if needed.

Command	Position
420803	1
	2
	3
420890	4
	5
	8
	9

Thank you!

[sunny_talwar]

Try Peek() function:

Table:

LOAD If(Len(Trim(Command)) = 0, Peek('Command'), Command) as Command,

     Position

FROM

[https://community.qlik.com/thread/197295]

(html, codepage is 1252, embedded labels, table is @1);

[sinanozdemir]

Hi,

Maybe something like this:

And here is your data model:

I am also attaching qvw.

Hope this helps.