My Online Training Hub

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

Append Table2 Categories for each item in Table1?|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Append Table2 Categories for each item in Table1?|Power Query|Excel Forum|My Online Training Hub

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
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
Append Table2 Categories for each item in Table1?
Avatar
KENNETH BATILO
Member
Members
Level 0
Forum Posts: 32
Member Since:
January 30, 2020
sp_UserOfflineSmall Offline
1
November 30, 2023 - 5:39 am
sp_Permalink sp_Print

I'm not sure how to word this properly, but I have TABLE1 with items and TABLE2 with categories.  Is there a way to append each line item in TABLE 1 with TABLE2?

TABLE1

Item Description
ITEM1 DESCRIPTION1
ITEM2 DESCRIPTION2
ITEM3 DESCRIPTION3

TABLE2

Category
CATEGORY1
CATEGORY2
CATEGORY3
CATEGORY4
CATEGORY5

Desired result

Item Description Category
ITEM1 DESCRIPTION1 CATEGORY1
    CATEGORY2
    CATEGORY3
    CATEGORY4
    CATEGORY5
ITEM2 DESCRIPTION2 CATEGORY1
    CATEGORY2
    CATEGORY3
    CATEGORY4
    CATEGORY5
ITEM3 DESCRIPTION3 CATEGORY1
    CATEGORY2
    CATEGORY3
    CATEGORY4
    CATEGORY5

 

Thanks in advance!

sp_AnswersTopicSeeAnswer See Answer
Avatar
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Moderators
Level 1
Forum Posts: 1109
Member Since:
January 31, 2022
sp_UserOnlineSmall Online
2
November 30, 2023 - 5:25 pm
sp_Permalink sp_Print

So I assume you have already connected to both Table1 and Table2. Then, in the Table1 query, you add a Custom column with the formula:

=Table2

Now expand the new column with Tables and you will get what you describe. Though 'Item' and 'Description' will be repeated on each row.

sp_AnswersTopicAnswer
Answers Post
Avatar
KENNETH BATILO
Member
Members
Level 0
Forum Posts: 32
Member Since:
January 30, 2020
sp_UserOfflineSmall Offline
3
December 2, 2023 - 2:18 am
sp_Permalink sp_Print

wow lol that was insanely simple...  thank you so much!

Avatar
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members

Moderators
Level 1
Forum Posts: 1109
Member Since:
January 31, 2022
sp_UserOnlineSmall Online
4
December 2, 2023 - 3:48 am
sp_Permalink sp_Print

Glad I could help!!

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria, Charles Johnson, Riny van Eekelen
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1944
SunnyKow: 1432
Anders Sehlstedt: 956
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Techia Braveboy
Charles Buchanan
Tiago Braga
Rehan Baig
Fred HORVATH
Silke Schmidt
Stuart Barr
Amelia Nolte
David Wier
T P Collins
Forum Stats:
Groups: 3
Forums: 25
Topics: 7154
Posts: 31382

 

Member Stats:
Guest Posters: 50
Members: 34655
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen