downloading an XMl

[samuel_brierley]

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

[marcus_sommer]

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

[samuel_brierley]

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.

[marcus_sommer]

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

[samuel_brierley]

No they'e all the same structure.

[marcus_sommer · Accepted solution]

Then I think you should use the wizard to create the load-statement and wrap this into a loop routine like this one:

Renaming CSV files using variables

[samuel_brierley]

excellent solution thanks