Forum Discussion
Looping over different data sources
Sure you can automatically concatenate tables with an Append command in M. I believe what you are looking for is to have a function that contains your common import code. Then, you would just pass the correct parameters into the function and your function would return a table which you would feed to the Append command. You main query script would probably include a List of the names that you would iterate over versus a FOR loop.
Sure you can automatically concatenate tables with an Append command in M. I believe what you are looking for is to have a function that contains your common import code. Then, you would just pass the correct parameters into the function and your function would return a table which you would feed to the Append command. You main query script would probably include a List of the names that you would iterate over versus a FOR loop.