Generate XML with Items under similar nodes

Thu, 14 Aug 2014 06:50:41 GMT

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

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

<_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.

Re: Generate XML with Items under similar nodes

Mon, 24 Nov 2014 10:03:15 GMT

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 .

Re: Generate XML with Items under similar nodes

Mon, 24 Nov 2014 10:11:37 GMT

Hi Yasar,

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

topic Re: Generate XML with Items under similar nodes in QlikView

Generate XML with Items under similar nodes

Re: Generate XML with Items under similar nodes

Re: Generate XML with Items under similar nodes