Forum Discussion
Solved
Repeat steps for different files (In a list)
Hi All, I have multiple excel files & and within those files are sheets that are similar in structure. I have come up with some transformations that can be applied to all of them. The only two i...
Start with a two-column table (filepath and sheet name), either with the Enter Data interface or bring in an Excel sheet with that info, and then on the Add Column tab click on Invoke Custom Function. You can then use the values from your two columns as the inputs, and then expand the resulting column of Tables.
Pat
Start with a two-column table (filepath and sheet name), either with the Enter Data interface or bring in an Excel sheet with that info, and then on the Add Column tab click on Invoke Custom Function. You can then use the values from your two columns as the inputs, and then expand the resulting column of Tables.
Pat
Works like a charm 😁
Thanks Pat!