Reading from mulitple xml files

Discussion on developing CloverETL engine, transformation components etc.

madan_clover3
Posts: 16
Joined: Tue Jun 10, 2014 10:39 am

Reading from mulitple xml files

Postby madan_clover3 » Thu Nov 24, 2016 1:43 pm

Hi,

I am trying to read data from 2 xml files and finally writing to one single xml file.
Mapping can happen in any combination from 2 source xmls to target xml.

Consider below scenario,

Source XML1:
SourceEntity1
___SourceEntity11

Source XML2:
SourceEntity2

Target XML:
TargetEntity1
___TargetEntity11
______TargetEntity111

Mapping is like,
TargetEntity1 ( is mapped from SourceEntity1)
___TargetEntity11 ( is mapped from SourceEntity2)
______TargetEntity111 ( is mapped from SourceEntity11)

Now I need to establish parent/child relation here, in between TargetEntity1 & TargetEntity111. TargetEntity111 records should be filtered based on TargetEntity1 record.

Please suggest available approches and suggestions.

Thanks in advance,
Madan.

cholastal
Posts: 103
Joined: Tue Sep 01, 2015 1:22 pm

Re: Reading from mulitple xml files

Postby cholastal » Mon Nov 28, 2016 2:30 pm

Hi Madan,

If you want to filter some fields based on other fields, you need to use some other components such as ExtFilter, Validator or Reformat. Such filtering cannot be done directly in the XMLWriter component.

If you want me to prepare an example for you, please provide me with valid input XML files and more detailed description of what the filtering should look like. Also, some graph you've been able to develop so far would be useful.

Best regards,
---
Lukas Cholasta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support