Forum Discussion
Solved
Append Repeated Values to Multiple Item Rows
I have two separate, non-related, tables. I want to add all the data from one table to each item on the other table. Table 1: Item B627 B630 B642 B643 B646 B647 BA04 BA14 BA15 Tab...
M code
NewStep=#table(Table.ColumnNames(Table1)&Table.ColumnNames(Table2),List.TransformMany(Table.ToRows(Table1),each Table.ToRows(Table2),(x,y)=>x&y))
DAX
NewTable=GENERATE(Table1,Table2)
spinfuzer
Solution Sage
Solution SageAdd Column =1 to both tables and merge the new custom column (faster performance)
Or Add Custom column =Table2 (slower performance). You can improve the performance with Table.Buffer, but it will still be slower than a merge. This means you do something like
buffer =Table.Buffer(Table2),
merge = Table.AddColumn(Source,"merge", each buffer)