issues Importing XML

[Anonymous]

How do I import all types of xml files. its obvious qlik doesn't import all xml files as I have been deadlocked with importing some xml files. Is there any standard in importing / reading xml files ?

[timpoismans]

Strange. I just tried to load the xml using that sample and it worked perfectly. Tried it using Qlik Sense Desktop and Server.

Same error as before?

What version of Qlik Sense are you using?

[Anonymous]

thanks ! the sample file works now but when I try to import the other file with

extra lines (fields) I get an error.

 Now I noticed that when I add this two lines.. the problem continues.

please try and see if you can add this to the one you have  and import

<sourceFileURL>http://cbjgxsu1.apis.me.com:5454/web/amDHLAIShowDoc/cgi-bin/showDGFBAM.html?action=get&target=/INVOICES/20181126/007538284s</sourceFileURL>

  <invoiceProcessID>Invoice=318695&Customer=KOMTSUam&Bill To Account=Uk J3655&Waybill=MSP067002&InvoiceDate=20181030&Interchange=50&Session=7538284</invoiceProcessID>

[timpoismans]

I have to admit, I don't use XML often to get data into my apps, but those two fields just seem like multiple fields combined into one.

And I guess the wizard (Excel and Qlik) is struggling with that.

But I sadly don't have any idea on how to fix those fields.

[Anonymous]

exactly, there is where the problem lies  excel and qlik are struggle to handle data with similar two lines.

I know there is a qlik script or qlik tweaks that can handle that

[timpoismans]

To be honest, if this happens with a customer, I'd just say that the data isn't pure.

You're trying to put multiple fields of data into one field, which I don't see the purpose of.

Good luck tracing the Qlik script that might help you and the issue in general. Sorry I couldn't be of more help.

Regards,

Tim P.

[marcus_sommer]

Like above mentioned you could go with the approach to clean and/or adjust the data before loading them as xml whereby a cleaning/removing of the invalid content is probably easier than to correct them. This might be done with any third-party tools like VBS but it's also possible within Qlik itself - which has a lot of very useful string-functions, for example textbetween() - and then loading it with from_field or with an intermediate storing of it as txt-file and loading from there.

Here is an example which is a bit similar to yours and which should be sufficient to give you an idea what is meant: felder-aus-feld-laden-load-xml-mit

- Marcus