How to change load from one drive to folder ?

[Anonymous]

Hi All

I am not going to transform my data loading from one drive to sharepoint , i like to know what i need to modify my code from which line ? so that dont set of data will be loading from sharepoint ?

this is the script for loading data from one drive folder :-

Below script is sample data file but load from sharepoint :-

[tex628 · Accepted solution]

This can't really be done in a simple way. When you create a Folder/Sharepoint query you also create functions automatically. You will need to go into the file with the folder query, create a new sharepoint query, targeting the same sourcefile and then swap the first 6 rows in the folder query with the first 7 rows in the sharepoint query. This will mean that the old folder query will now use the sample file, parameter and fuction generated by your sharepoint query so you can not delete these. 

Br,
J

[Anonymous]

Hi Sir

Thank you for your sharing. Okay it save me some more time for trying.

Paul Yeo

[Anonymous]

@Anonymous The first line where the path is provided, change that to the desired location.

[Anonymous]

Hi Sir

I have check line by line , and found that need to change all the first 7 line of code , till # " change type "

But then when i click okay , i get error msg , may i know those sample file 8 , 7 can i delete ?