Wildcard load from SharePoint

khigaurav999 — Wed, 25 Nov 2020 16:16:04 GMT

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

topic Wildcard load from SharePoint in QlikView

Wildcard load from SharePoint