Forum Discussion
Create a table from a main table with the M language
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
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 TeamIf 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
2 Replies
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
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 TeamIf 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
