Fill column null value with previous not null value

[jayati_shrivast]

Hi All,

I have a straight table layout as follows

ID             MODE       MSG

11                a                "how may i help u"

11                b                  null

12                a                 "may i know your name"

12                b                    null

13                 a                 "pls provide your contact details"

13                 b                    null

In place of null, I need to paste the same msg corresponding to particular ID  where mode = a  that is I should get the display as follows:

ID             MODE       MSG

11                a                "how may i help u"

11                b                 "how may i help u"

12                a                 "may i know your name"

12                b                  "may i know your name"

13                 a                 "pls provide your contact details"

13                 b                  "pls provide your contact details"

how can i implement this, pls help me out. In the database from where I am retrieving the data, for mode = b for all the id's msg  value is null. I need to implement the above in qliksense

Thanks

[arusanah]

hi Jayanti ,

Try this 

Data:
Load
ID,
MODE,
// MSG,
if( len(MSG ) = 0, peek(MSG), MSG) as MSG,

;

Fill_Data:
Load * Inline [
ID, MODE, MSG

11, a , "how may i help u"
11, b ,
12, a , "may i know your name"
12, b ,
13, a , "pls provide your contact details"
13, b ,
];