Loading XML

Wed, 10 Sep 2014 11:08:58 GMT

Hi All,
I want to laod XML file. While loading file from I am facing some problem.

Here is the piece of data from IE

claim '''Component Diagram'''</Field>
<Field Name="Business Process Diagram">CargoNetComponent.JPG,</Field>
<Field Name="ForWhatPage">BASEPAGENAME</Field>
<Field Name="1" />
<Field Name="2" />
</Template>
- <Template Name="Application's_Source_Code_Template">
<Field Name="Source Code Tool">SVN</Field>
<Field Name="Source Code With">Yes</Field>
<Field Name="ForWhatPage">BASEPAGENAME</Field>
<Field Name="1" />
<Field Name="2" />
</Template>
- <Template Name="Application's_Configurable_Items_Template">
<Field Name="Configurable Item">NA</Field>
<Field Name="ForWhatPage">BASEPAGENAME</Field>
<Field Name="1" />
<Field Name="2" />

After loading into QlikView the above script is coming in one single field like this
'''Component Diagram'''</Field><Field Name="Business Process Diagram">CargoNetComponent.JPG,</Field><Field Name="ForWhatPage">BASEPAGENAME</Field><Field Name="1"></Field><Field Name="2"></Field></Template><Template Name="Application's_Source_Code_Template"><Field Name="Source Code Tool">SVN</Field><Field Name="Source Code With">Yes</Field>Field Name="ForWhatPage">BASEPAGENAME</Field><Field Name="1"></Field><Field Name="2"></Field></Template><Template Name="Application's_Configurable_Items_Template"><Field Name="Configurable Item">NA</Field><Field Name="ForWhatPage">BASEPAGENAME</Field><Field Name="1"></Field><Field Name="2"></Field></Template><Template Name="Application's_Others_Template"><Field Name="Others">'''Interface Diagram - Webster SurveyAgent Updater'''

But I want to get all the field names individually which are under template for eg

Business process diagram

ForWhatPage

Source Code Tool

Configurable Item

Thanks in Advance
Sonali

Re: Loading XML

Gysbert_Wassenaar — Wed, 10 Sep 2014 11:19:02 GMT

Don't load it as a text file, but as an XML file. Use the File Wizard:

Choose Xml as File Type and then select the right table on the Tables tab:

Re: Loading XML

Wed, 10 Sep 2014 13:27:36 GMT

Hi Gybsert,

Now I am able to get all the field names but there is an issue.

For eg

There is a field called Application Name and against that field there are some 9 values

Everest
Activity Tracking
ACL
Acrash
APR
So I want to get all the correct values against all fields but there is only one field and all the values are coming in one single field.

PFA

Regards

Sonali

topic Loading XML in QlikView

Loading XML

Re: Loading XML

Re: Loading XML