Replicating the Last field Value

[#1]

Hey Community,

I have a two columns in data where one has values till 80 and the other has only 20.

Now I want to replicate the value of 20 in Second column till 80. as below

A     B

1     01    

.      02

.     03

5     04

10     900

11     901

.     .

.     .

.     .

20     910    

.     910

.     910

.     910

.     910

80     910

How can I do that??

Thanks in Advance.

[vinafidalgo]

Can you upload your QVW document?

[sunny_talwar]

So the values between 20 and 80 are missing or null()? and the above provided data is the intended output or input?

[#4]

Hi Sunny,

The values are Null for 21 - 80.

Those values are just as an example...I want replicate the  value of 20 for 21 to 80.

[#5]

No, I cant.

[nagireddy_qv]

Hi,

Check this once.

Fill with last non null value during script load

[#7]

I don't think this meets my requirement. May be we can use to replace the Null value.

Can you please post how to replace the null value with my last number 910.

[MarcoWedel]

please post a sample application to demonstrate with.

thanks

regards

Marco

[#9]

Hey Marco,

Please below attached is the sample date. Hope this helps

[MarcoWedel · Accepted solution]

Hi,

maybe one solution could be:

given your source:

table1:
LOAD A,
    If(Len(Trim(B)),B,Peek(B)) as B
FROM [https://community.qlik.com/servlet/JiveServlet/download/981305-212759/exp1.xls] (biff, embedded labels, table is Sheet1$);

hope this helps

regards

Marco