Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export each line as a distinct file

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.

13 Replies
Kushal_Chawda

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

Not applicable
Author

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.

Not applicable
Author

Any clue?

Anonymous
Not applicable
Author

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?

Not applicable
Author

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?

Not applicable
Author

Image1.png

Anonymous
Not applicable
Author

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?