How to change the Value in Colums in the Load Statement

[henrybergemann]

Hello

i load a column where nearly every Field is blank, but i want to give the blank  column the the same Value in the Load Expression.

But Keep all the value that are allready in die Field

I tried it with a where Statement, but that didnt workout....

Thank you for Help

[trdandamudi]

Not clear on your requirement, can you please share sample data along with your required output please...

May be as below:

Load
If(Len(Trim([Your Field Name Here]))=0,'Blank Value',[Your Field Name Here]) as FieldName;

Note: Please substitute [Your Field Name Here] with your table fieldname.

Hope this helps...

[vishsaggi]

Can you share some sample data with an expected output? Something like your fields where you have blanks and what you tried on?