My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Create a Table from Columns|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Create a Table from Columns|Power Query|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Create a Table from Columns
Avatar
Robert Rafferty
Member
Members
Level 0
Forum Posts: 32
Member Since:
September 15, 2020
sp_UserOfflineSmall Offline
1
September 22, 2020 - 2:48 pm
sp_Permalink sp_Print

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

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4524
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
September 22, 2020 - 4:13 pm
sp_Permalink sp_Print

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

Avatar
Robert Rafferty
Member
Members
Level 0
Forum Posts: 32
Member Since:
September 15, 2020
sp_UserOfflineSmall Offline
3
September 23, 2020 - 9:21 am
sp_Permalink sp_Print

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

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4524
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
4
September 23, 2020 - 11:21 am
sp_Permalink sp_Print

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. 

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Louis Muti
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Blair Gallagher
Brandi Taylor
Hafiz Ihsan Qadir
Gontran Bage
adolfo casanova
Annestine Johnpulle
Priscila Campbell
Jeff Mikles
Aaron Butler
Maurice Petterlin
Forum Stats:
Groups: 3
Forums: 24
Topics: 6369
Posts: 27852

 

Member Stats:
Guest Posters: 49
Members: 32359
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen