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 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
Hi ,
Im having the same issue, I started with a single csv file. Lots of steps were then created to transform the data, I then added lots of new measures etc and reports
I now want to change the datasource to a folder with multiple files. I clicked on source in Applied Steps but you have to specify a file name to change it. I then went to New source and created my new folder source which just created me a new data set with none of my steps or new measures against it. All my tiles are based on the previous data source.
Im not sure what you mean by...
"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."
To me it looks like you cant change from a single file data source to a folder. Any help would be appreciated.
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
