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

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
iAT long string to XML
 Login/Join
 
Member
posted
In Adapter Transformer, I have a long string in the format

HeaderData Item1DataElement1 Item1DataElement2 Item2DataElement1 Item2DataElement2

I need to transform it into XML in the format

<HeaderData>
HeaderData
</HeaderData>

<ItemData>
<Element1>
Item1DataElement1
</Element1>
<Element2>
Item1DataElement2
</Element2>
</ItemData>

<ItemData>
<Element1>
Item2DataElement1
</Element1>
<Element2>
Item2DataElement2
</Element2>
</ItemData>

The problem is that I can't figure out how to get the items into their appropriate sections. I was thinking that it would take two transforms. The first would get the data into the format

<HeaderData>
HeaderData
</HeaderData>

< Item1DataElement1>
Item1DataElement1
</Item1DataElement1>

< Item1DataElement2>
Item1DataElement2
</ Item1DataElement2>

< Item2DataElement1>
Item2DataElement1
</ Item2DataElement1>

< Item2DataElement2>
Item2DataElement2
</ Item2DataElement2>

Then I thought I could translate this to the final format, but iAT won’t let me translate both Item1DataElement1 and Item2DataElement1 into Element1.

I’m open to either a correction in my strategy or a whole new one.

This message has been edited. Last edited by: tbush,
 
Posts: 2 | Registered: April 19, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Hi tbush,

Our internal expert reviewed this topic and suggested that this does not seem to be something to be done naturally. For further research, a case may be of better help because we will need to see a full example with much more details.

To open a case with Information Builders' Customer Support Services, you may either call at 1-800-736-6130, or access the online system InfoResponse at http://techsupport.ibi.com. Here is a list of information to be ready when you call: http://techsupport.ibi.com/before_you_call.jsp.

Hope this helps. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 


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