

August 21, 2019

Hi Catalin Sir,
Previous you had shared with me on the List.Accumulate usage on List of deliminters, when I applied the same codes second time (Trim2) all became blank ?
For your advise please
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Documents", type text}}),
Trim1 = List.Accumulate(Table2, #"Changed Type", (TransformedTable, ReplacementItem) =>
Table.TransformColumns(TransformedTable, {{"Documents", each Text.BeforeDelimiter(_, ReplacementItem), type text}})),
Trim2 = List.Accumulate(Table3, Trim1, (TransformedTable, ReplacementItem) =>
Table.TransformColumns(TransformedTable, {{"Documents", each Text.AfterDelimiter(_, ReplacementItem), type text}}))
in
Trim2
1 Guest(s)
