Null rows in qlik sense

[anuhegde]

Hi Team,

Below is the data I have in qliksense.

BrNo, ICNo,Amount

<Null>, <Null>, 100

<Null>, <Null>, 200

<Null>, <Null>, 300

<Null>, <Null>, 400

123,        456,     500
789,        102,     600

The output I need is

BrNo,Amount

<dummy value1>, ,100

<dummy value2>, 200

<dummy value3>, 300

<dummy value4>, 400

123,        456,     500
789,        102,     600

Could you please help?

Thank you

Anusha

[anat]

     If(len(trim(MyField))=0, autonumber(rand()),MyField) as MyField1