Hi see sample belowI have 2 tables, Company column combines the table.How do I get a table combining Table 1 and 2 in table 3.For my output I need a table 3 which looks at various breakdowns in the combined table.The table 3 need to be used standalone.

Hi Anonymous Code in Advanced editor of Table2_copy let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSs7PLUjMq1RwVNJRMjYwAJKW+sYG+kYGhhZAtlN+fnZYYk5pKpANohNLMvPzlGJ1EPqcgDImZOhzBsqYEqsvFgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [company = _t, amount = _t, date = _t, transaction = _t, type2 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"company", type text}, {"amount", Int64.Type}, {"date", type date}, {"transaction", type text}, {"type2", type text}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Table1), #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"company", "sector", "deal type"}, {"Custom.company", "Custom.sector", "Custom.deal type"}), #"Added Conditional Column" = Table.AddColumn(#"Expanded Custom", "Custom", each if [company] = [Custom.company] then 1 else null), #"Filtered Rows" = Table.SelectRows(#"Added Conditional Column", each [Custom] <> null and [Custom] <> ""), #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Custom.company", "Custom"}), #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"company", "Custom.sector", "Custom.deal type", "amount", "date", "transaction", "type2"}), #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Custom.sector", "sector"}, {"Custom.deal type", "deal type"}, {"transaction", "transaction"}}), #"Appended Query" = Table.Combine({#"Renamed Columns", Table1}), #"Sorted Rows" = Table.Sort(#"Appended Query",{{"amount", Order.Ascending}}) in #"Sorted Rows" Change source path with yours Best RegardsMaggie Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Combining 2 tables | Microsoft Fabric Community

Forum Discussion

Related content

Tables combine

2 tables connected (related) by 2 tables

Combine 2 rows into 1

Combining 2 tables both have duplicate values, need help!

Create rows from 2 tables