Create a table from a main table with the M language

[huguo_90]

Hi there,

I am looking to create a new table independant of 5 columns with the M language in order to select some elements from a main table of 30 columns. I don't really know the M language. How to do it please. Thanks in advance.

Have a good day. 

Huguo

[Anonymous · Accepted solution]

Hi @huguo_90 ,

In Power Query Editor -> Check the table -> Right-click and click Reference.

In copy -> Select the desired column and  Right-click and click remove other columns.

Next, you can filter the fields by clicking on the small arrows on the fields.

Table.SelectColumns - PowerQuery M | Microsoft Learn

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[jbwtp]

Hi Huguo,

If I understand this correctly, you do not need M for this. Just select the [5] columns in the main [30 column] table and then righ-click and select Remove Other Columns  from the context menu.

Cheers,

John