How to Loop through Systems and Append?

[wickert11]

Thank you in advance I'm new to power query so any guidance is greatly appreciated. 

I typically create a connection and query for each system but now as I have 100+ systems and will need to be able to update the query frequently I need some way of looping through the systems and appending the data. 

I have my list of systems stored in a separate table. 

let
Source = Odbc.DataSource("dbq=RTW001A.WORLD;dsn=RTW", [HierarchicalNavigation=true]),
RTW_Schema = Source{[Name="RTW",Kind="Schema"]}[Data],
JOB_CODE_Table = RTW_Schema{[Name="JOB_CODE",Kind="Table"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(JOB_CODE_Table,{"JBCD_JOB_CODE", "DESCRIP"})
in
#"Removed Other Columns"

[miguel · Accepted solution]

Hey!

You can parametrize some of the logic inside your query and then convert your query into a function and use it as reusable piece of logic.

Below is the official documentation on how to create a custom function in Power Query:

Using custom functions in Power Query - Power Query | Microsoft Docs

Hope this helps!

[wickert11]

Each System has an identical table structure. It's just different locations