Load from Web file and write xml file without double quote

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I'm using a public webservice to test load data.

Reading from webservice I'm able to write a xml file, with data.

But at the begginig and at the end of that file it writes double quotes ' " '.

Is there any way to remove them without manually editing the xml file ?

I've attached a sample app.

Thanks in advanced,

Sílvia

Re: Load from Web file and write xml file without double quote

engishfaque — Tue, 27 Dec 2016 14:54:39 GMT

Deara Silvia,

I have checked your shared file "fromRT.qvw" and also checked URL "http://www.webservicex.net/globalweather.asmx/GetCitiesByCountry?CountryName=Portugal" where from you are extracting/loading data into QlikView.

Here are the findings regarding your App:

1. Given below text is missing in your given URL link (webservice link). Therefore, you are not able to see correct fields during loading data into QlikView. So, it is requested to you kindly add below text in your service page ".xml" file and again extract/load data into QlikView.

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

2. You are extracting/loading field "string%Table" from your ".xml" webservice. The field ""string%Table" is composed of two fields called Country and City and you are expecting both fields will automatically loaded into QlikView instead of "string%Table" and you will easily add them in your QlikView App.

So, point number 2 is coming due to missing of point number 1 xml statement.

However, I made local file which is exactly copy of your webservice ".xml" file. New file name is "requestNewFile.xml" and added point number 1 xml statement in newly created file. I loaded newly created "requestNewFile.xml" file into QlikView, again stored with new name "request.xml" as you mentioned in your file and again loaded the 2nd newly created file "request.xml" file and it is working fine. "request.xml" did not create any double quote ' " ' as you mentioned in your question.

Summary of the answer is, just add <?xml version="1.0" encding="UTF-8"?> in your webservice ".xml" file, load, store and add fields in QlikView App.

For more, I am sharing you sample files as you can understand easily.

Kind regards,

Ishfaque Ahmed

topic Re: Load from Web file and write xml file without double quote in QlikView

Load from Web file and write xml file without double quote

Re: Load from Web file and write xml file without double quote