Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

rgopalsamy
2012-06-06 05:52:58

Can you any one please help us for below query?

Thanks
Rajesh

rgopalsamy
2012-06-06 02:31:54

Thanks...Do we have any other option in current Talend version?

Can we create XML text file using XML tags?

Please help us any other option?

Thanks
Rajesh G

pedro
2012-06-04 11:01:11

Hi

Sorry. I think about your requirement for a long time and it seems to be impossible to create a job with dynamic XML tags.

Regards,
Pedro

rgopalsamy
2012-06-04 09:48:08

Hello..

Hope your doing fine. I have job reading data from Database and creating XML  and loading into GeoNetwork web.

I need to create dynamic XML tags based on now of rows....

For Ex :-

Product ID                                     ProdDesc
------------                                     ----------
ANZ5001                                       ANZProductDesc1

the product id and ProdDesc values are coming form database, this product id has only one description, so my output of XML like this.

<gmd:Product>
       <gmd:Product_ID>
           <gco:CharacterString>ANZ5001</gco:CharacterString>
       <gmd:Product_ID>
       <gmd:MD_Product_Desc>
           <gmd:ProdDesc>
             <gco:CharacterString>ANZProductDesc1</gco:CharacterString>
           </gmd:ProdDesc>
        </gmd:MD_Product_Desc>
<gmd:Product>



Product ID                                     ProdDesc
------------                                     ----------
ANZ5001                                       ANZProductDesc1
                                                    ANZProductDesc2
                                                    ANZProductDesc3

If, above Product id has three product desc rows then, i need to create three dynamic XML tags for ProdDesc, the output expected like this...

<gmd:Product>
       <gmd:Product_ID>
           <gco:CharacterString>ANZ5001</gco:CharacterString>
       <gmd:Product_ID>
       <gmd:MD_Product_Desc>
           <gmd:ProdDesc>
             <gco:CharacterString>ANZProductDesc1</gco:CharacterString>
           </gmd:ProdDesc>
           <gmd:ProdDesc>
             <gco:CharacterString>ANZProductDesc2</gco:CharacterString>
           </gmd:ProdDesc>
           <gmd:ProdDesc>
             <gco:CharacterString>ANZProductDesc3</gco:CharacterString>
           </gmd:ProdDesc>
        </gmd:MD_Product_Desc>
<gmd:Product>


So could please advise me how to create dynamic XML tags based on now of rows. Please find enclosed the job screen shot also.

Thanks
Rajesh G

Board footer

Powered by FluxBB