Null Change to Shipping

[KC3]

Hi,

I wanted to change my null variant_sku value into Shipping_Chgs. But i am doing somting wrong the data is not coming right.

Please look into it and help me to solve it.

PFB SS for the same, i wanted to change in Script.

Result as there are more sku but i ama getting only Variant Sku, Shipping

[Or]

Perhaps use Coalesce(variant_sku,'Shipping_Chgs')?

You could also use the if(Isnull()) formula but you would probably want to remove the quote from 'variant_sku' if you're trying to get that field's value, rather than the string 'variant_sku'.

[BrunPierre · Accepted solution]

Try:

If(Len(Trim(variant_sku))=0,'Shipping_Chgs',variant_sku),