Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 .
Hi Yasar,
I did not find any solution so far I had to use a work around myself in my coding.