Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to know if it is possible to use a script or a Qlikview functionnality to export each line from a table as a distinct file, I my case, I want it as XML files.
Thank you all,
Best regards,
Yasser.
Yes, it is possible. But why you want to do it?
Here is the situation:
I have file where there is some useless data and some XML. i want to make stats over the XML content, so I first used an ETL to keep only the XML tags. Having done that I have a table where in each line a have an entire XML file (only this line missing in each file <?xml version="1.0" encoding="UTF-8"?>)
What I want as a result is to load all that files in Qlikview in order to have a table and as fields the content of the tags.
Any clue?
Hi,
it is very intresting but how can you do this?
I need to do this also.
Thank you very much.
Best regards.
Can you share one file, so that I can try to read?
I can't share the file because it contain peoples personnal names and data. Can you tell me the function or solution to save or export each line as a distinct XML file?
Excuse me Kush,
but are you sure that is possible to export each line to a distinct XML file?
I think that I should use a macro but I dont understand how I can assign the file name (and which).
Thank you very much.
Best regards.
All you files are in same format?