Export each line as a distinct file

[#1]

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.

[Kushal_Chawda]

Yes, it is possible. But why you want to do it?

[#3]

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.

[#4]

Any clue?

[Anonymous]

Hi,

it is very intresting but how can you do this?

I need to do this also.

Thank you very much.

Best regards.

[Kushal_Chawda]

Can you share one file, so that I can try to read?

[#7]

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?

[#8]

[Anonymous]

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.

[Kushal_Chawda]

All you files are in same format?