Hi all,
I have something similar to the following tables:
Table1:
...
Table2:
...
And would like to add [Weight] as a new column to table2 based off [Product] in table2 starting with [Product] in table1. I have the following but can't seem to get it to work:
Table.SelectRows(
table1[Product],
Text.StartsWith([Product],table1[Product])
)
Any help would be greatly appreciated
Thank you
Hi @Will-4655
With the data you exposed the following does it - code for Table2:
let
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
ChangedTypes = Table.TransformColumnTypes(Source,{
{"Product", type text}, {"Category", Int64.Type}}),
AddedWeight = Table.AddColumn(ChangedTypes, "Weight",
(tbl2) => Table.First(
Table.SelectRows(Table1, each Text.StartsWith(tbl2[Product], [Product]))
)[Weight],
Int64.Type
)
in
AddedWeight
Corresponding sample avail. here
2 people are following this question.
