How do I create a separate table from 3 columns from an existing table. I want to merge existing table to new table, eventually.
I read through M documentation and viewed a couple of videos, still not clear.
Thanks
Robb
Hi Robb,
I'm not 100% clear on what you want, but if you want to merge a table to itself, you can do this by selecting the table in both drop downs in the merge dialog box.
Alternatively, if you want to make further modifications to the data, then you can duplicate the query for the purpose of creating a separate table that consists of the 3 columns you want. In the Power Query editor, right-click the query name > Duplicate.
Mynda
Hi Mynda:
Thanks, makes sense.
What does the Table.FromRecords function do. Is this an alternative to duplicating the query and keeping three columns?
Thanks
Robb
Not really. Table.FromRecords creates a table from lists. You've got tables that you want to extract columns from to make a new table.
