Hello,
I select data from database, and map to a document. Some of the data values are Null, but I don’t want to show Null in the xml file. How should I do?
Thanks and Regards
Hello,
I select data from database, and map to a document. Some of the data values are Null, but I don’t want to show Null in the xml file. How should I do?
Thanks and Regards
Hi,
‘Drop’ the field in document by checking it value for NULL.
Branch
Sequence:Field=NULL
Drop the element in Document
HTH!
Or if you want to keep your code clean and don’t want to use too many branch steps then you can use regular expression on conditional mapping i.e. when mapping link turns blue. For more information check the developer’s user guide->D Conditional Expressions->Checking for Variable Existence.
Thanks a lot.