Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi people,I 'm new in this forum and I have few experience with the qlikview tool.
I have question about load information:
I need to connect a my ERP System by http protocol. I have done to connect succesfully and the system retunned this xml (view below). Then, I need captured the fields and values that this are inside of the "tag".
I have tried System's ETL but I don't find a solution, can you help me ??
Thanks a lot for advance and I'm sorry for my english... 🙂
from Barcelona,
Miquel.
You can process the returned XML with load from FIELD.
-Rob
Hi Rob,
Thanks a lot, but my problem is this from returned XML:
...
<content name="P_LIFNR" ...>XXXvalueXXX</content>
...
With load from FIELD, this operation capture this data: field = name , value ='P_LIFNR
By example:
and I need this situation --> field = P_LIFNR and value XXXvalueXXX
How I can do with the load?
MIquel.
Take a look at using the TextBetween() function and possible the subfield() function to parse the data out the way you want.
-Rob