XML Import

[#1]

Hi,

i have a Problem with the Import of an XML file:

for example i have to select the Feature type 'PROD_FEAT_14839' and then i only want to see the '2' but qlikview Shows me in the listbox '2' , '35mm' , '1' ,  'Ja' ....... so i cant select items for a specific Feature like '35mm'

can someone help?

<feature featureName="Anzahl Schnittstufen"

               featureType="PROD_FEAT_14839"

               languageKey="de_DE">2</feature>

      <!--Free text value: 2, 4, 6-->

      <feature featureName="Schnittbreite"

               featureType="PROD_FEAT_11921"

               languageKey="de_DE">35 mm</feature>

      <!--Free text value: 35 mm-->

      <feature featureName="Anzahl Aufsteckkämme"

               featureType="PROD_FEAT_10167"

               languageKey="de_DE">1</feature>

      <!--Free text value: 1, 2-->

      <feature featureName="Längenverstellbare Aufsteckkämme"

               featureType="PROD_FEAT_11427"

               languageKey="de_DE">Ja</feature>

      <!--Nein, Ja-->

[sgrice]

This is an issue with the XML. The Free Text value is not associated with  'PROD_FEAT_14839' it is an element in its own right.

You may have to load the XML as TEXT lines and Parse it yourself using between()

[#3]

the Problem is that i have about 1.000.000 items...

so i cant use this file

[sgrice]

I do not see why the size makes any difference.

Load the file has text into qlikview and then extract the data you need from the xml yourself using the between() function.

I have done this on xml with billions of items works just fine.

[#5]

oh i thought i should make it Manual, but i don't know how i have to work with the between.function

i made a csv file but in the listbox Feature there are all the Features i don't get the right result.

is it difficult to explain what i have to do ?