0 Replies Latest reply: Feb 13, 2018 3:54 AM by Gaurav Khinchi RSS

    Wildcard load from SharePoint

    Gaurav Khinchi

      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:

      SP field not found error.jpg

       

      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

      [X:\Web Message Data\201711 201712\*.xlsx]

      (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