How to change this table GL CODE to 10026 ?

[paulyeo11]

Hi All

I have import a GL Table into QV .

I want to change all the GL CODE number 10026 , Now it have many other number.

I try :-

if(@1:16T='','10026') as GL_CODE_NEW1,

it does not work , as it return nul value.

Hope some one can advise me.

Paul

[paulyeo11]

Enclosed my QV doc

[Anonymous · Accepted solution]

Hi,

Try below,

If(Len(Trim(@1:16T))=0, '10026') as GL_CODE_NEW1,

[paulyeo11]

thank you work now