Replace the Blank Values with Unique number or key

[Anonymous]

load *  Inline [

TempID,Data

1,A

2,BB

3,

4,CC

5,DD

6

];

need to generate a unique number/text for each data field with blank value

TempID,Data

1,A

2,BB

3,111

4,CC

5,DD

6,22

];

[sunny_talwar · Accepted solution]

May be like this

If(Len(Trim(Data)) = 0, RecNo(), Data) as Data