Loading XML

[#1]

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

[Gysbert_Wassenaar]

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:

[#3]

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