Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] inserting XML data as multiple records
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] inserting XML data as multiple records
 Login/Join
 
Silver Member
posted
Hi Friends,

I have a requirement of storing a xml data as multiple records in oracle table.

Here is my sample input:


ABC
City

A-1
B-1
C-1

....
.
.
.


I want this to be inserted in my table
as follows
storename storelocation partnum
ABC City A-1
ABC City B-1
ABC City C-1

But this one is getting inserted like this
as I didn't use any iteration.

storename storelocation partnum
ABC City A-1|B-1|C-1


Can anyone suggest me a highlevel logic to insert as a separate row in the table.

Thanks in advance,
Mary Gerald...

This message has been edited. Last edited by: <Kathryn Henning>,


7.7.04M, Windows 7 , HTML, PDF,EXCEL
 
Posts: 36 | Registered: April 11, 2012Reply With QuoteReport This Post
Silver Member
posted Hide Post
Sample input

 
<SEARCH>
<STORENAME>ABC</STORENAME>
<STORELOCATION>City</STORELOCATION>
<PRODUCT>
<PARTNUM> A-1 </PARTNUM>
<PARTNUM> B-1 </PARTNUM>
<PARTNUM> B-1 </PARTNUM>
</PRODUCT>
.
.
</SEARCH>


7.7.04M, Windows 7 , HTML, PDF,EXCEL
 
Posts: 36 | Registered: April 11, 2012Reply With QuoteReport This Post
Guru
posted Hide Post
Save your sample as mary.xml and then from New, Synonym select the XML adapter and create a synonym using the xml as a source. Sample data returns separate rows. Then use DataMigrator to load.

 
Posts: 373 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks for the reply clif.

But looks like the screen shot is for Iway DataMigrator.

I think I wasn't clear enough.

I need this in Iway Integration Tool.


7.7.04M, Windows 7 , HTML, PDF,EXCEL
 
Posts: 36 | Registered: April 11, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] inserting XML data as multiple records

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.