Remove Empty Attributes in XQuery
Here is how you can remove empty attributes while xQuery mapping. Consider the following input xml: Input: Case 1: <product> <code>MAX</code> </product> Expected Result: <FinalProduct ProductCode="MAX" > </FinalProduct> Case2: <product> <code/> </product> Expected Result: <FinalProduct> </FinalProduct> Thus, we don't want the attribute to be present if the mapped element is null. Please find the below snippet for the above problem: <FinalProduct> { if((fn:boolean(data($product/code)))) then attribute ProductCode { data($product/code) } else () } </FinalProduct> Thanks, Rohan Lopes