topic Re: Regarding XML Load in QlikView

Regarding XML Load

Mon, 18 Aug 2014 15:36:06 GMT

Dear Friends,

I am trying to load an XML file into QlikView but after reload I found there is no association between the table fields. Kindly share some examples for loading from XML file into QlikView if you have one.

Thanks,

Kiru

Re: Regarding XML Load

Mon, 18 Aug 2014 16:13:14 GMT

There might be no association because of maybe no common field names between tables. You can just rename the key fields to associate the necessary tables.

Tab:

Load

Field1 as Key,

Field2,

....

From XML file;

Re: Regarding XML Load

Mon, 18 Aug 2014 16:20:26 GMT

Hello Ajay,

I appreciate your time!

As of now I am trying to reload only one table.

After reload into QlikView, I am not able to found any associations between the fields in the table

For Eg:

I am reload a table wthe 3 fields namely ID,Firstname and Lastname.

After reload, If I click on ID, the corresponding Lastname and Firstname is grayed out and similarly for the other fields as well.

I have attached a file for your reference,Kindly let me know if you need any further details!

Regards,

Kiru

Re: Regarding XML Load

Mon, 18 Aug 2014 16:27:40 GMT

Oh I see your issue now. Can you attach your XML file as well please

Re: Regarding XML Load

Mon, 18 Aug 2014 17:07:29 GMT

Hello Ajay,

I sincerely appreciate your time!

I got the result anyways 🙂 and as I am retrieving the XML Response from a QVSource, I did some change in the web file link and now I achieved the result!

Thanks so much for your time!

Kiru