topic Re: source us XML file in QlikView

source us XML file

Tue, 17 Dec 2013 09:55:19 GMT

Hi Experts,

Anyone having a QVW along with XML file ? If yes, could you please share to me..

I tried reading from a XML. But it displays data to a single records.Where as my XML file contains 100 records.

Hope some one will understand the issue I am facing.

Regards,

Re: source us XML file

Peter_Cammaert — Tue, 17 Dec 2013 11:22:52 GMT

We might be able to understand the issue you are facing if we knew where to look.

XML files can be mightily different since the language itself allows for extreme customization, even programming.

The best thing you can do is post your XML file (or a sample) here so that we can get you a QV model that is able to read its content.

Best,

Peter

Re: source us XML file

Anonymous — Tue, 17 Dec 2013 11:55:53 GMT

It sounds like you are only reading in the definition and not the data itself. When you are importing the XML are you seeing two tables in the File Wizard? If so, one of them should contain the data and this will be visible in the preview window. When you select this table and Finish the wizard it should set up the load script to load the fields and also create a second table for the definitions.

Re: source us XML file

ramkrishna86 — Tue, 17 Dec 2013 12:07:45 GMT

Use data transformation in qlikview while loading data from XML file.

Re: source us XML file

Tue, 17 Dec 2013 18:51:48 GMT

<?xml version="1.0" encoding="UTF-8"?>

<data>

<A>

<contact_id/>

<status>Deleted</status>

</A>

<contact_id/>

<C>

<contact_id/>

<status>Complete</status>

</C>

</data>

Above is XML file content. When tried to read in Qlikview able to see the below.

But actually it is (To My knowledge) supposed to be 2 columns(ID,STATUS) with 2 records.

Hope I explained the scenario in an understandable way.

Re: source us XML file

Anonymous — Wed, 18 Dec 2013 09:01:52 GMT

I'm no expert in XML but from my understanding of it the <A>, and <C> tags are what is causing the problem here. You can see from the Fields list that you are getting 'A/id', 'B/id' and 'C/id' instead of an ID field containing all three values. They are being translated as three different types of container instead of three versions of the same container.

If you created this XML yourself then you may want to check the formatting. If you received it from somewhere else there might be a document definition that will help QlikView understand the structure.

Re: source us XML file

VishalWaghole — Wed, 18 Dec 2013 11:47:31 GMT

Hi Consultant QV,

Your XML file should be like this,

<?xml version="1.0" encoding="UTF-8"?>

<data>

<A>

<contact_id/>

<status>Deleted</status>

</A>

<A>

<contact_id/>

</A>

<A>

<contact_id/>

<status>Complete</status>

</A>

</data>

Your tags A,B and C was wrong......

- Regards,

Vishal Waghole

Re: source us XML file

senpradip007 — Wed, 18 Dec 2013 12:40:14 GMT

Try this

<?xml version="1.0" encoding="UTF-8"?>

<data>

<DT>

<A>

<contact_id/>

<status>Deleted</status>

</A>

</DT>

<DT>

<contact_id/>

</DT>

<DT>

<C>

<contact_id/>

<status>Complete</status>

</C>

</DT>

</data>

Re: source us XML file

Mon, 03 Feb 2014 10:10:24 GMT

Thanks VishalWaghole. I hope it is you are perfect !