Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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-->
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()
the Problem is that i have about 1.000.000 items...
so i cant use this file
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.
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 ?