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: 
Mike_Coulson
Contributor
Contributor

Qlik Script Specify Format File

Hello everyone,

I am working with a client that uses characters after extension name, like bellow :

AAA-01.xml.2019-09-05

BBB-01.xml.2019-09-05

The client don't want to change the files names.

I didn't succed to implement these file in qlik sense by droping them.

Mike_Coulson_2-1695913747917.png

 

Is there a way to specify the file extension type in the script ?

I already tried

LOAD

*

FROM [lib://DataFiles/AAA-01.xml.2019-09-05]
(XmlSimple, table is []);

and i got this error:

Mike_Coulson_1-1695913648458.png

Thank you,

Mike.

Labels (2)
0 Replies