topic XML Import in QlikView

XML Import

Tue, 16 Jun 2015 08:27:45 GMT

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>

<feature featureName="Schnittbreite"

featureType="PROD_FEAT_11921"

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

<feature featureName="Anzahl Aufsteckkämme"

featureType="PROD_FEAT_10167"

languageKey="de_DE">1</feature>

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

featureType="PROD_FEAT_11427"

languageKey="de_DE">Ja</feature>

Re: XML Import

sgrice — Tue, 16 Jun 2015 09:04:47 GMT

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()

Re: XML Import

Tue, 16 Jun 2015 09:39:55 GMT

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

so i cant use this file

Re: XML Import

sgrice — Tue, 16 Jun 2015 09:44:40 GMT

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.

Re: XML Import

Tue, 16 Jun 2015 10:19:35 GMT

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 ?