XML Format output

devanars · Post by **devanars** » Sun Mar 22, 2009 4:14 pm

We were required to store the data(merge of two source columns) in xml format of a target table column.

The Req is like this

Source table has columns like A,B and C. Target table has two columns A and D. col A directly can map to target A but source B need to be display in first line and col C in second line of the target coulmn D. The data type of col D is CLOB.hope i have given clear information.

Source:
A B C
10 20 30

Target required format:
A-------------D
10-------<'B> 20 <\B>
----------<C> 30 </C>

any advise regarding the above. Thanks

eostic · Post by **eostic** » Mon Mar 23, 2009 4:23 am

to confirm.....the target that you are looking for is not really "xml"...just that you have certain chunks inside of the target that are "formatted like xml tags"?

...based on what you have below, I'd just use a Transformer and build the string that you need.

How many columns are there? If in fact, there are 20 or 30 B and C columns that need xml tags, then I'd craft a way to use the xml stage, but for only 2 to maybe 10, a transformer is just as easy, especially if you are needing to care about the crlf's..... are the exactly line formats important?

Ernie

devanars · Post by **devanars** » Mon Mar 23, 2009 7:35 am

We need to get xml tags also for both B and C. Actually we need to get only two columns like that. but both the columns has long text data so that we have assigned data type as CLOB.

Appreciate your help if you can advise the procedure of getting those output with tags. Thanks

Pagadrai · Post by **Pagadrai** » Thu Mar 26, 2009 1:10 am

Hi,
can you explain the requirement more clearly with 2 sample input records and expected output.

As Ernie said, you can just append the xml tags if that gets you the required result.
Else, you need to use XML output stage for each output column to convert it to XML.
Is your output a DB or a file ?

devanars · Post by **devanars** » Thu Mar 26, 2009 6:59 am

I need to get xml structure at the output. output is a DB.

eostic · Post by **eostic** » Thu Mar 26, 2009 2:15 pm

and it's just those two columns? Build the xml string in a transformer. Don't waste your time with the xmlOutput Stage. It does far more than you need here for this solution.

Ernie

devanars · Post by **devanars** » Thu Apr 23, 2009 7:48 am

Any sugession to start second line. I need to store two lines on one field. how can i close the first line and start second line. any function is there to use! Just i am hard coding the text in the transformer.Please advise.Thanks

chulett · Post by **chulett** » Thu Apr 23, 2009 7:56 am

Just build them together as one line, formatting like that is just for peoples and will not affect any XML parser. If for some reason you really think you need to do this, concatenate a <CR> between the two elements:

Code: Select all

FirstTag : Char(13) : SecondTag