Reading from mulitple xml files

madan_clover3

• November 24, 2016 00:00

• Answered

Follow

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.

• 

  Lukas Cholasta

  • November 28, 2016 13:30

  0

  Comment actions Permalink

  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,

Please sign in to leave a comment.