Forum Discussion

Dicken's avatar
Dicken
Post Prodigy
7 months ago
Solved

Concatenate lists ;

Hi,  This give the result i want but does anyone have ideas to make more dynamic  or just better approach  so start = {"A","B","C"}   , result =  {{ "A","C"} , {"A","B"} , {"AC"} , {"AB"} }     ...
Need Help
Show and Tell
  • AlienSx's avatar
    AlienSx
    7 months ago
    let
    Source = {"A", "B", "C"},
    w = List.TransformMany(
        List.Skip(Source), 
        (x) => {x, {x}},
        (x, y) => if y is text then {Source{0} & y} else {Source{0}} & y
    )
in
    w
AlienSx's avatar
AlienSx
Super User
7 months ago
let
    Source = {"A", "B", "C"},
    w = List.TransformMany(
        List.Skip(Source), 
        (x) => {x, {x}},
        (x, y) => if y is text then {Source{0} & y} else {Source{0}} & y
    )
in
    w
Dicken's avatar
Dicken
Post Prodigy
7 months ago

Thanks i  don't use TransfromMany enough,  

Richard