Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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