How To Remove Empty XML Tags in TIBCO BusinessWorks

[Manoj Chaurasia]

I have a BusinessWorks process which renders an XML file at the end. How do I remove the empty XML tags during mapping of the fields

[Manoj Chaurasia]

I've hundred of mapped fields in BusinessWorks Design processes and they are optional fields but I don't really want to go through each one of them and insert a "When Condition" to map only if data exists in the XPath Formula Builder. This is time consuming. Is there a quick and better way of doing this

[Manoj Chaurasia]

You can try going into the .process file with a text editor and search/replace directly.

[Manoj Chaurasia]

I Have same problem. Please help me if you got the answer. also let me know which function I can use to check When Data Exists

[Manoj Chaurasia]

1) You can check whether value exists or not multiple ways a) using exists() function, this function checks whether the xml tag is coming or not. For ex if the element tag is coming as

[Manoj Chaurasia]

Thanks for your reply....But is there any way to check for all at one time instead of doing for each element I have around 20 elements to check..

[Manoj Chaurasia]

If A1,A2, A3 are your source elements and which are optional.B1,B2,B3 are your target elements and if you are mapping one-to-one then you have to apply if(EXISTS()) function for each element. You can't apply only one IF condifition if any subset of elements may come in the source element.

 

In case if your scenario is some thing like the source xml contains all of A1,A2,A3 or none of them (not a subset of A1,A2,A3) then you can apply a single IF condition on the top.

[Manoj Chaurasia]

Ajit's solution works good. Just to add to it, if you would also want to eliminate the additional spaces that appear instead of the tags, they can be done using the xslt below:

 

 

 

Thanks,

Soumya

[Manoj Chaurasia]

Hello all,

 

Just a quick question regarding performance issue : Is the XSL sheet loaded each time my process def. will be trigerred or once

 

Thanks for your help.

 

Arnaud

[Manoj Chaurasia]

Thanks

[Manoj Chaurasia]

Thanks a million that's what exactly what Iam searching for

[Manoj Chaurasia]

hi

If your empty element is required, you can't remove it and must set a value for it. If your element is optional, you shouldn't set any value for it and this element won't write in your xml output.

 

Steel

[Manoj Chaurasia]

You can easily achieve it using XLST transformation. Save below content to a XSLT file. Then use XSLT tranformation activity in Tibco to remove emtty element.

 

The input to XSLT tranformation activity is below file name and the XML with empty elements

 

 

 

 

 

 

 

 

 

 

 

Thanks,

Ajit

[Manoj Chaurasia]

you can add this property "java.property.automatic_mapper_if_surround=true" to add surround with if function for optional to optional fields so that we will not see empty tags in xml's..

[Nitin Pawar 2]

If we do not map any value, we get an empty close xml tag. but its a single closing tag. Is there any way we can get and empty open and close tag for values we have no mapping

[Jurgen Jacobs]

did you ever found a solution for this

[George Obretin]

Hi, could you say where to add this property "java.property.automatic_mapper_if_surround=true"