Append queries based on excel cell values.

Hi Anonymous 

They say "eval is EVIL", but in PowerQuery it's an angel 👼!

Given:

...and TLSeasonFilter is:

WHEN MasterChartLL is:

let
    Source = TLSeasonFilter,
    #"Added WithSuffix" = Table.AddColumn(Source, "WithSuffix", each [Season] & "_LL_SP"),
    //                                                                          ^^^^^^^^ - all have same suffix, right?
    #"Removed Other Columns" = Table.SelectColumns(#"Added WithSuffix", {"WithSuffix"}),
    TableToList = Table.ToList(#"Removed Other Columns"),
    listOfTables = List.Accumulate(
        TableToList, {}, (final, current) => List.Combine({final, {Expression.Evaluate(current, #shared)}})
    ),
    ret = Table.Combine(listOfTables) // assumes all tables have same header
in
    ret

Then you should get what you want - if I understood it correctly. 😉

Please mark this as ANSWER if it helped.

P.S.: currently the TLSeasonFilter controls what tables get appended. If you want SS24_LL_LP to be always present, just add it to the List.Accumulate seed: instead of "{}", use "{Expression.Evaluate("SS24_LL_SP", #shared)}"