topic Reuse Element names in QlikView

Reuse Element names

Mon, 21 Jul 2014 12:39:34 GMT

Hello,

I have some questions on Qlikview's load script.

My dataset looks like this :

<brand>

<id>brand1</id>

<name>Brand 1</name>

</categories>

</brand>

<brand>

<id>brand2</id>

<name>Brand 2</name>

</categories>

</brand>

</brands>

The results I want should look like this :

Name	Category
Brand 1	Jeans
Brand 2	Coats
Brand 2	Parkas
Brand 2	Shorts

As you can see the problem is that the category names are tag names and that there are unlimited number of elements under the <categories> tag.

How can I get the tag name from an element and how can I link it to the brand name ?

It is possible to do that in the Load script ?

Thank you,

anita mazur

Re: Reuse Element names

struniger — Mon, 21 Jul 2014 12:59:26 GMT

How about this (test.xml is just your data as given in your question).

// Start of [test.xml] LOAD statements

brand:

LOAD id,

name,

[categories/jeans] as jeans,

[categories/coats] as coats,

[categories/parkas] as parkas,

[categories/shorts] as shorts

FROM [test.xml] (XmlSimple, Table is [brands/brand]);

// End of [test.xml] LOAD statements

tCategory:

Crosstable(Category, value, 2)

LOAD

RESIDENT

brand

;

Category:

LOAD

,Category

,value

RESIDENT

tCategory

WHERE value > 0;

DROP TABLE tCategory;

Re: Reuse Element names

Mon, 21 Jul 2014 14:55:54 GMT

Thank you very much. it works !