Forum Discussion
Extracting data from same Excel template files
Anonymous then what you should do is get data from a folder and not an individual file in your getdata method, apply all those steps once you have done a combine (as long as they all the same, it will copy the first file format)
that way you can apply it to multiple files or if you dont want to combine them, then i suggest creating a source parameter that you can create on one and copy and paste in all, or a function
combine : https://www.youtube.com/watch?v=RAmSdxt863s
functions/parameters: https://www.youtube.com/watch?v=GgwXt4LVmsU
Anonymous then what you should do is get data from a folder and not an individual file in your getdata method, apply all those steps once you have done a combine (as long as they all the same, it will copy the first file format)
that way you can apply it to multiple files or if you dont want to combine them, then i suggest creating a source parameter that you can create on one and copy and paste in all, or a function
combine : https://www.youtube.com/watch?v=RAmSdxt863s
functions/parameters: https://www.youtube.com/watch?v=GgwXt4LVmsU
Dear vanessafvg,
Thank you for your assistance. The function/parameters video got me close, I did had a feeling it is on the good way to solve but in the end, did not work. That was the way I thought it would be possible to solve it but did not work.
I will dig deeper into it and in case I find a feasible solution, share it here.