Forum Discussion
Change Source from File to Folder?
Hi CoreyP,
When you make a connection to a folder you have to the folder you have 3 options/sub-options on the bottom :
- Combine
- Combine & Edit
- Combine & Load
- Load
- Edit
If you choose the first one with the option of Edit you will get created function that allows you to make a mockup of your data treatment that then will be applied to all file on your folder check the link to get further information.
You can then copy all of your steps from the first query to the table with the name Transform Sample File From FileName and get the expected result.
This can also be made by hand if you want to be a little more insightfull of what is being done chech this link with another example
Regards,
MFelix
- Combine
Hi DebbieE,
If you go to the Advance Editor in the query view, you can replace the steps you have to the ones of the single file.
You need to mkae a new query based on a folder, then go to your first query and copy in the advance editor view the steps of the transformation of the data, go to the Transform Sample File query and copy the steps also in the advance view editor, this will change the way the sample file is treated without having to repeat every step.
Regards,
MFelix
Thank you, that will save some time