tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

Four Stars

tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

I need to prevent tAdvancedFileOutputXML from creating empty elements. Basically there are rows in tAdvancedFileOutputXML which have no mapping from tMap so the corresponding elements should not be created. Please help

Moderator

Re: tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

Hello,

Here is an option "Create empty element if needed" in Advanced settings of tAdvancedFileOutputXML component.

Have you tried to uncheck it to see if it is OK?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

Hi,

This was the very first thing I tried but seems that doesnot works the way it states because it still shows empty elements

 

Forteen Stars

Re: tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

@aishvarya,can you share your smaple input and requied out ,so that i wil test.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

,i have tested please check the below way is usefull to you?
Untitled.pngUntitled.pngUntitled.pngUntitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

I tried but still getting elements in xmls, I placed &nbsp in the mapping column in the xml rows mentioned in tAdvancexmloutput. Moreover I came across one more issue where if a mention a single space in the column data, ie " ".toString the corresponding xml element in the generated xml gives me two spaces. Need help on this too.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads