Wildcard load from SharePoint

[khigaurav999]

Hi Folk,

I get the field not found error when I load the files with wildcard from SharePoint. Also, when I keep the complete file name it works:

This doesn't work -

[WEB_MSGS]:                                                   

LOAD

     F1,

     [MH Txn Month Year],

     [MH Svc Name],

     [MH Svc Tier],

     [MH Svc Provider Code],

     [MH User Domain],

     [MH User Group],

     [MH User ID],

     [MH Agent Sine],

     [MH App ID],

     [MH Txn Count]

FROM $(vSP_WebMessageDataMappings_Dir)*.xlsx (ooxml, header is 3 lines, embedded labels, table is [Report 1]);

I get the following error:

When I try with single file with absolute name of it - it works.

[WEB_MSGS]:                                                   

LOAD

     F1,

     [MH Txn Month Year],

     [MH Svc Name],

     [MH Svc Tier],

     [MH Svc Provider Code],

     [MH User Domain],

     [MH User Group],

     [MH User ID],

     [MH Agent Sine],

     [MH App ID],

     [MH Txn Count]

FROM $(vSP_WebMessageDataMappings_Dir)2P_SWS_by_Carrier_and_Date.xlsx (ooxml, header is 3 lines, embedded labels, table is [Report 1]);

When I access and load them thru mapped SharePoint drive on my local, they work fine.

LOAD F1,

     [MH Txn Month Year],

     [MH Svc Name],

     [MH Svc Tier],

     [MH Svc Provider Code],

     [MH User Domain],

     [MH User Group],

     [MH User ID],

     [MH Agent Sine],

     [MH App ID],

     [MH Txn Count]

FROM

(ooxml, embedded labels, header is 3 lines, table is [Report 1]);

Any idea, why is it happening with the wildcard load? I also made sure that all the files have fields needed.

Thanks,

Gaurav