Forum Discussion

tyan's avatar
tyan
Icon for Helper II rankHelper II
4 years ago

Sharepoint folder to get data with error

I got this message while I edit query. I get five worksheet from share point folder. I was wondering how to fix this problem. Could someone please help. I seasched online and it said I need to ...
Need Help
serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
4 years ago

Hi,

you can try to create another query on folder and this time choose as sample file IAP and not IFR.

I think you'll get a specular error.

Then you can try to load the two type of files in two separate queries.

It will be simplier to find a solution

  • tyan's avatar
    tyan
    Icon for Helper II rankHelper II
    4 years ago

    In realiaty, I actually expect to get many files into one from different share point folders. If this is the case, am i need to create as many queries as many files

    • serpiva64's avatar
      serpiva64
      Icon for Solution Sage rankSolution Sage
      4 years ago

      Not really, you need to create as many query as many combination of folder and type of file (if folder contains only one tipe you can get it in one time). Later you can consolidate your data in one or more query with append or merge and load only the final queries.