Power Query also allows you to create a list query from a data table available. The column from the given data table can be used to create a list query. This can be explained with the help of an example.
Creating A List Query From A Table Column
Here, we have a data table containing product details. We want to create a new query for the column ProductName from this data table. To do so, we need to follow the below steps.
Step 1: Select the Column for creating List Query
First, load the data table ‘Products’ into the Power Query. Then, select the column ‘ProductName’ from the data table as shown below.
Step 2: Create a List Query
To create a list query from the selected column, right click on the column and select ‘Add as New Query’ option as shown in the picture below.
NOTE: You can also use Table.ToList() function in Power Query (M) language for creating a list from a data table.
Step 3: Close & Apply
When you click on ‘Add as New Query’ option, Power Query immediately creates a new list Query for you as shown below. You can now Close & Apply the changes for the future.
You can learn more:
- How to Manage Parameters in Power Query
- How to Create Grouped Serial Numbers In Power Query
- Do Comments In Query Steps in Power Query
- Steps to Adding Comments In M in Excel