Ask Your Question

Convert XML File content to multiple records

asked 2017-11-14 04:26:47 -0600

Vivian Y gravatar image

updated 2017-11-17 16:40:50 -0600

metadaddy gravatar image

Having issues convert xml files from one record to multiple record.
I tried used xml parser to convert , no error , but no output records produced. Is "Xml Parser" the correct processor to use for this use case?

Exampe Source Data

My expected values will be something like this

Expected values

edit retag flag offensive close merge delete


My xml file tag <root> contain <txnid> <eventlist> One <eventlist> will having multiple of <event>

Vivian Y gravatar imageVivian Y ( 2017-11-14 04:28:31 -0600 )edit

Can you add a small example of your file to the question, and a brief description of what you want the records to look like? I think you might be able to do this with XML Parser.

metadaddy gravatar imagemetadaddy ( 2017-11-16 12:06:50 -0600 )edit

2 Answers

Sort by ยป oldest newest most voted

answered 2017-11-16 23:17:37 -0600

metadaddy gravatar image

I was able to parse similar data be setting Delimiter Element to /MtxEventRecordData/EventList/Event

image description

edit flag offensive delete link more

answered 2017-11-14 05:28:30 -0600

Vivian Y gravatar image

Notice that XML Parser and XML flatterer are used for one single field that contain XML data. I managed to split the record using read, and put on custom delimiter of my root data and use field pivoter to seperate the child record.

edit flag offensive delete link more


Hi Vivian, could you please clarify on using the field pivoter to separate the child record? Any screenshots you could provide would be great. Thanks!

rthebest gravatar imagerthebest ( 2018-02-25 21:32:51 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-14 04:26:47 -0600

Seen: 3,254 times

Last updated: Nov 17 '17