topic Loading file with unknown mail in QlikView

Loading file with unknown mail

Fri, 06 Nov 2009 21:39:43 GMT

Hi:

One of our data suppliers places a daily xml file on an FTP server. Unfortunately, it has every day a different name. I was wondering whether somebody knows how to include a 'joker' in part of the file name? The file names that they place on their server have names along the following examples:

CMSIA_20091106130933.xml and CMSRA_20091106130933.xml

The large number is a timestamp. I would like to put a 'joker' instead of the timestamp so all files are fetched accordingly.

The code I am using now looks as following:

Directory;

// Start of [CMSRA_20091106130933.xml] LOAD statements

RouteUpdate:

LOAD

CMSRouteArchiveId,

CMSRouteId,

RouteAverage,

ArchiveDate

FROM [ftp://ftp.domain.com/CMSRA_20091106130933.xml] (XmlSimple, Table is [RoutesUpdate/RouteUpdate]);

// End of [CMSRA_20091106130933.xml] LOAD statements

Anybody a suggestion?

Thanks

Jochem

Loading file with unknown mail

GabrielAraya — Fri, 06 Nov 2009 21:55:15 GMT

Did you test with:

FROM [ftp://ftp.domain.com/CMSRA_*.xml] (XmlSimple, Table is [RoutesUpdate/RouteUpdate]);

GAG

Loading file with unknown mail

Fri, 06 Nov 2009 22:02:54 GMT

That is the first thing I was thinking as well. Unfortunately, it resulted in an error message informing me that the object could not be found.

Loading file with unknown mail

Fri, 06 Nov 2009 22:11:24 GMT

The only way to use jokers is to create a batch to copy ftp files locally.

Jokers won't work using FTP location directly.

Rgds,

Sébastien