Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
henrybergemann
Creator
Creator

How to change the Value in Colums in the Load Statement

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

2 Replies
trdandamudi
Master II
Master II

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
Champion III
Champion III

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