Replacing Null text values with a value

[#1]

Hi -

I am trying to replace blank text field values using the following expression.

=if(WildMatch([Text],'*NULL*'),'Testing',[Text])

For some reason this formula does not work and blank rows were not replaces with 'Texting'.

Please help.

Thank you!

[vardhancse]

Hi,

Can try this:

In chart Expression:

=IF(Len(Trim(Dim))=0,'N/A',Dim)

Even in script also we can use

[afsarshaikh]

Try this,

=if( len([Text] < 0, 'Testing', [Text])

)

[prieper]

Might be worth to challenge your datamodel.

Are you supposed to have missing entries, or can you fix somehow in the script by reducing linked fields (e.g. using LEFT JOIN or LEFT KEEP).

Can you post an example in order to validate, whether it comes from data or from the datamodel?