txmlmap - create empty element function does not exist

Four Stars

txmlmap - create empty element function does not exist

So, I have an XML master file and some daily files who should have the same structure (schema).
I created the structure according to the master, but when trying to load the daily files, the job failed and I suspect it has to do with some rows in the daily file that look like this - <DenialReason xsi:nil="true"/>. 

My assumption was (after long long googling and pls correct me if I'm wrong) that I need to allow empty cells, 
but the option does not exist in the output options. 

pls advise. Capture.PNG

Community Manager

Re: txmlmap - create empty element function does not exist

Four Stars

Re: txmlmap - create empty element function does not exist

Hey,

I think I'm facing a different problem and also, it does not explain why I'm missing this option in the output side of the txmlmap (as shown in my post).
I don't wish to set a default value for the attribute, but rather to allow it to insert data or leave it blank, as it comes from the XML file. 
That's why I thought perhaps allowing empty cells could resolve it. 

I'm not sure if it is a relevant info, but my job (which probably could be designed in much efficient way, but I'm still learning) looks like this -  

image.png

tnx. 

Smiley Happy

Highlighted
Community Manager

Re: txmlmap - create empty element function does not exist

Sorry, I think you may be right. I may have seen your problem from the wrong perspective. Do you get an error at all? Can you post it? It sounds like this may be to do with column configurations where you require a value. Do you get a NullPointerException by any chance?

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog