XMLExtract Extracting Wrong Field

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

harvardpan
Posts: 1
Joined: Tue Jan 26, 2016 4:09 am

XMLExtract Extracting Wrong Field

Postby harvardpan » Tue Jan 26, 2016 4:17 am

I'm using CloverETL Designer Community, Version 4.1.1.040. I'm trying to use the XMLExtract component, but running into a strange issue that seems like a bug. I've created a small reproducible graph to illustrate the problem.

Here is the Graph
xml-bug.grf
(2.03 KiB) Downloaded 230 times


Here are the two input files
notWorking.xml
xml with the campus element
(300 Bytes) Downloaded 244 times

working.xml
xml without the campus element
(218 Bytes) Downloaded 226 times


In the nonWorking.xml, I'm trying to get the <individual> element's id attribute (value is 162). However, the graph ends up picking up what I believe to the campus's id attribute (value is 1). In the working.xml, I removed the campus element and the correct value is picked up. Per a previous thread, I made sure that the auto map is not set and that the output metadata is mapping to a field called individualid instead.

Is this a bug, or is there something that I can do in the mapping XML to ensure that it picks up the right id value?

Thanks so much!
Harvard

slechtaj
Posts: 192
Joined: Wed Aug 15, 2012 8:18 am

Re: XMLExtract Extracting Wrong Field

Postby slechtaj » Mon Feb 01, 2016 5:30 pm

Hi Harvard,

The issue is caused by "Use nested nodes" attribute (true by default) in XMLExtract. You can easily resolve the issue if you turn the attribute off.

Hope it helps.
Jan Slechta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

How to speed up communication with CloverCARE support


cron