Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i am using excel vba to generate a download script for qlikview. below is the result of one (theres hundreds hence why i get excel to write for me)
LOAD status as [Origin Element Status], |
origin_address as [Origin Address], |
destination_address as [Destination Address], |
[row/element/status] as [Destination Element Status], |
[row/element/duration_in_traffic/value] as [Duration (Traffic (s))], |
[row/element/duration_in_traffic/text] as [Duration (Traffic (hr))], |
[row/element/distance/value] as [Distance (m)], |
[row/element/distance/text] as [Distance (km)], |
[row/element/duration/value] as [Duration (no traffic (s))], |
[row/element/duration/text] as [Duration (no traffic (hr))], |
'A34 NB' as route |
FROM [URL]; |
problem is qlikview defaults to delimited file type, how can i change this so it knows this is XML?
thanks
Then I think you should use the wizard to create the load-statement and wrap this into a loop routine like this one:
Have you tried to load your xml-file per table-wizard which had an option to load xml-files (but it will need well-build xml-structures - if you have only pseudo-code it won't work).
- Marcus
Thats exactly what i want to try and avoid. There are hundreds of tables so it would be miles easier if i could define the format in the script.
The hundreds of xml-files are all different in their structures or you have a few different types and from each one then many?
- Marcus
No they'e all the same structure.
Then I think you should use the wizard to create the load-statement and wrap this into a loop routine like this one:
excellent solution thanks