topic Re: Inserting Raw xml with each row in Cassandra in Talend Studio

Inserting Raw xml with each row in Cassandra

Anonymous — Sat, 16 Nov 2024 11:07:31 GMT

Hi ,
i am processing multi loop xml and using txml map for that. I want to insert raw xml for each row corresponding to the respective id. Please help me on how i can achieve this.
Suppose i have data like:
<Details>
<Identifier>273985234</Identifier>
<officecode>XO</officecode>
<ReNum>1237161</ReNum>
<Country>
<CountryCode>SM</CountryCode>
<CountryCode>HJ</CountryCode>
<CountryCode>GJ</CountryCode>
<CountryCode>ZX</CountryCode>
</Country>
<ServicesDetails>
<Services>
<TestCode>TestData</TestCode>
<DetailDesc>
<DescClass>
<NumberClass>34</NumberClass>
</DescClass>
<DescClass>
<NumberClass>64</NumberClass>
</DescClass>
</DetailDesc>
</Services>
</ServicesDetails>
</Details>
I also want to insert the raw xml corresponding to identifier with every row.
Thanks,
Saurabh.

Re: Inserting Raw xml with each row in Cassandra

Anonymous — Tue, 11 Aug 2015 04:16:42 GMT

Hi Saurabh,

Could you please also paste your expected result here?

Best regards
Sabrina

Re: Inserting Raw xml with each row in Cassandra

Anonymous — Mon, 04 Jul 2016 08:09:05 GMT

Hi Sabrina,
I want my result to be :
273985234,XO,1237161,"SM,HJ,GJ,ZX",TestData,34,64,"<Identifier>273985234</Identifier> <officecode>XO</officecode> <ReNum>1237161</ReNum> <Country> <CountryCode>SM</CountryCode> <CountryCode>HJ</CountryCode> <CountryCode>GJ</CountryCode> <CountryCode>ZX</CountryCode> </Country> <ServicesDetails> <Services> <TestCode>TestData</TestCode> <DetailDesc> <DescClass> <NumberClass>34</NumberClass> </DescClass> <DescClass> <NumberClass>64</NumberClass> </DescClass> </DetailDesc> </Services> </ServicesDetails> "