Sharepoint folder to get data with error

[tyan]

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

[serpiva64]

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]

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]

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.