Ask Your Question
2

Convert XML File content to multiple records

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

Vivian Yang 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

Comments

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

Vivian Yang gravatar imageVivian Yang ( 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
1

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
2

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

Vivian Yang 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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 1,205 times

Last updated: Nov 17 '17