Forum Discussion
What is the Transform File from Query doing?
It is not 1 query, but 4 queries that are grouped.
It contains the logic required to combine the files from your folder.
The set of queries is created automatically when chosing "Combine Binaries" in the column header of the column in the navigation table with the files in your folder, along with 4 additional query steps in your "Toggl" query.
You may get rid of it by converting the files to tables, using native functions like Csv.Document or Excel.Workbook, depending on the file types in your folder.
But why would you get rid of it? You can also collapse the group.
Thanks for explaining it MarcelBeug.
It is clearer to me now what is it trying to do.
I was trying to convert a local folder data source into a Sharepoint Folder one and am thinking that it is this Transform File Query that is preventing me from doing it since it references different query names.
Does this make sense?
If I understand your posts correctly, you only want to change the source from a local folder to a sharepoint folder, so basically, both folders have the same (type of) content.
If you go back to your working version (with the local folder), you need to adjust the source folder in 2 places:
1. In your main query (Toggl).
2. In query "Sample File".
That should solve your issue.
thanks MarcelBeug, that makes sense.
I was trying to do that on my other post but could not get it to work.
Any ideas on why do I get that error? and how to correct it?
Hi Anonymous,
You need to find out what the errors exactly are in the error message. Then correct them.
Best Regards,
Dale
