Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
bgiri2430
Frequent Visitor

Need to create table basee on two different table

I need to create a table C based on two different tables. Table A is having 10 column where table B is having 4 columns and there is no any matching key. Table A is a field parameter. Please assist?

1 ACCEPTED SOLUTION

@bgiri2430 
duplicate table A then create a Custom column in 
Table.AddColumn(#"Added Custom", "Table B", each TableB) give table name after that expand custom column and get you output.Thank You!!

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Hca5DQAhEATBXMbG4MfmOQhitfmncVKXVWaaCkoxyYNp8cw3L/zwyj/e+OWdPz7k/gM=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Product = _t, #"Product ID" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Product", type text}, {"Product ID", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Table B", each TableB),
    #"Expanded Table B" = Table.ExpandTableColumn(#"Added Custom", "Table B", {"Category", "Category Id"}, {"Category", "Category Id"})
in
    #"Expanded Table B"

@bgiri2430  I hope you getting my point.

View solution in original post

5 REPLIES 5
bgiri2430
Frequent Visitor

@Mahesh0016 

As I mentioned table A is field parameter. When we are moving to power query mode the table won't be available into power query that's the issue

Mahesh0016
Super User
Super User

@bgiri2430  it is possible it's the End Result looks like the below Screen Shot.

 

Mahesh0016_0-1689860649731.png

@bgiri2430 Thank You!!

@Mahesh0016 

 

Could you please assist with procedure how you approcahed

@bgiri2430 
duplicate table A then create a Custom column in 
Table.AddColumn(#"Added Custom", "Table B", each TableB) give table name after that expand custom column and get you output.Thank You!!

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Hca5DQAhEATBXMbG4MfmOQhitfmncVKXVWaaCkoxyYNp8cw3L/zwyj/e+OWdPz7k/gM=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Product = _t, #"Product ID" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Product", type text}, {"Product ID", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Table B", each TableB),
    #"Expanded Table B" = Table.ExpandTableColumn(#"Added Custom", "Table B", {"Category", "Category Id"}, {"Category", "Category Id"})
in
    #"Expanded Table B"

@bgiri2430  I hope you getting my point.

Mahesh0016
Super User
Super User

@bgiri2430 Please Can you Share your Table C Output After A & B Merge. Thank You!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.