// Append1
let
Source = Table.Combine({Scheme_A, Scheme_B}),
TSC = Table.SelectColumns(Source,{"Stock Invested in", "% of Total Holdings"}),
Ren = Table.RenameColumns(TSC,{{"% of Total Holdings", "of Total Holdings"}}),
KD = let columnNames = {"Stock Invested in"}, addCount = Table.Group(Ren, columnNames, {{"Count", Table.RowCount, type number}}), selectDuplicates = Table.SelectRows(addCount, each [Count] > 1), removeCount = Table.RemoveColumns(selectDuplicates, "Count") in Table.Join(Ren, columnNames, removeCount, columnNames, JoinKind.Inner),
Grp = Table.Group(KD, {"Stock Invested in"}, {{"Count", each _, type table}}),
List = Table.AddColumn(Grp, "of Total Holdings", each [Count][of Total Holdings]),
Ext = Table.TransformColumns(List, {"of Total Holdings", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
Split = Table.SplitColumn(Ext, "of Total Holdings", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"% of Total Holdings A", "% of Total Holdings B"}),
Type = Table.TransformColumnTypes(Split,{{"% of Total Holdings B", Percentage.Type}, {"% of Total Holdings A", Percentage.Type}})
in
Type
Bookmarks