Forum Discussion
Apply same transformations to multiple tables/excel sheets
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.
Thank you for the reply.
I manage to do it through a parameter that focuses on a list generated with unique values of a column of a table, changing the default value that forces you to enter the parameter. But how to make the parameter have that list as a default value and not a single value of it? Or do you have put it another way to generate all the tables with the same transformation at once?
The data source function = folder applying merge and transform data, generates a sample file (which in our case would be a value of the list (list extracted from the column values of a table).
How is it solved with M code?
Thank you very much in advance to any help.
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.