Forum Discussion
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 transform data there to change IFR_sheet to 0. but the entire thing still not work.
Need your help. Thanks
3 Replies
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
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
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.
