Generate XML with Items under similar nodes

[#1]

Hi Experts,

I have a situation here.

I have a table box in qlikview with has Brand and Product Family as two columns. When I do a export of this table in XML format I have the XML output as the following:

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

     <TableBox>

     <_empty_>

          <Brand_x0020_Name>BRAND1</Brand_x0020_Name>         

          <Product_x0020_Family>PRD1</Product_x0020_Family>

     </_empty_>

     <_empty_>

          <Brand_x0020_Name>BRAND1</Brand_x0020_Name>

          <Product_x0020_Family>PRD2</Product_x0020_Family>

     </_empty_>

     <_empty_>

          <Brand_x0020_Name>BRAND1</Brand_x0020_Name>    

          <Product_x0020_Family>PRD3</Product_x0020_Family>

     </_empty_>

     <_empty_>

          <Brand_x0020_Name>BRAND1</Brand_x0020_Name>

          <Product_x0020_Family>PRD4</Product_x0020_Family>

     </_empty_>

     </TableBox>

However I wish the output to be in the below format:

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

     <TableBox>

     <_empty_>

          <Brand_x0020_Name Title="BRAND1">     

          <Product_x0020_Family>PRD1</Product_x0020_Family>

           <Product_x0020_Family>PRD2</Product_x0020_Family>

          <Product_x0020_Family>PRD3</Product_x0020_Family>

          <Product_x0020_Family>PRD4</Product_x0020_Family>

          </Brand_x0020_Name>

     </_empty_>

     </TableBox>

How can i achieve this?

Please kindly help.

Thank you in advance.

[#2]

Hi Pramod

Im facing the same issue . Did you get any solution for your problem , if so please help to solve the issue regarding the xml export .

[#3]

Hi Yasar,

I did not find any solution so far I had to use a work around myself in my coding.