Forum Discussion
Solved
Apply same transformations to multiple tables/excel sheets
Good afternoon I'm looking for a way for the transformations I apply to modify a set of tables or Excel sheets. Something similar to when we connect to a folder, select "combine and tran...
That's what I meant when I wrote: "Apply the transforms against one of the sheets or files, then extract the code into a function, then apply that function to all sheets or files".
A parameter can be fed from a list query. But that's rather pointless as you can instead use that query directly in your ETL.
Apply the transforms against one of the sheets or files, then extract the code into a function, then apply that function to all sheets or files. Similar to what you would do in Excel where you record a macro for your steps and then examine the resulting macro to include in your code.