fbpx
[email protected] +1 203-349-9909 / +91-8080042523

Steps to Create A List Query From A Table Column

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.

SELECT COLUMN TO CREATE LIST QUERY

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.

BECOME A DATA ANALYST COURSE
• Power BI • Advanced Excel • Excel Dashboard • Excel VBA • SQL Programming Language • SAS Programming • many more

 

NOTE: You can also use Table.ToList() function in Power Query (M) language for creating a list from a data table.

CREATING A LIST QUERY

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.

AFTER CREATING A LIST QUERY

You can learn more: