I have made a small example with the solution.
Please find the solution attached.
The following code (similar to the one of Shree ana) was used:
if(IsNUll([Field with Nulls]), 'NA', [Field with Nulls]) as [Nulls converted to NA]
Your code works great when the nulls are created when there is missing data in a table created in the LoadScript. However, I can't get your solution to replace the nulls if the missing data is loaded from an XLSX file. See attached. Any ideas what I am doing wrong?
Are you sure you are loading Nulls and not empty values or blanks?
Have you used the trim function, to remove the blanks?
Also check out:
, KR Koen