Forum Discussion
How to Loop through Systems and Append?
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"
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!
2 Replies
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!