Forum Discussion
Syndicate_Admin
Administrator
AdministratorApply 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.
lbendlin
Super User
Super UserApply 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.