Four Stars

Inserting Raw xml with each row in Cassandra

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.
2 REPLIES
Moderator

Re: Inserting Raw xml with each row in Cassandra

Hi Saurabh,

Could you please also paste your expected result here?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Inserting Raw xml with each row in Cassandra

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> "