Append Existing Tables Variable Number of Times using Text.Combine

[SStrange]

So my question is... is there a way to repeat the Table.Combine append a variable number of times?

My initial though was to use Text.Repeat nested in Text.ToList to create the range with the number of times being variable using a criteria created by a number count.

let
TC01 = TagCount,
AppIpt = AppendInput,
Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
#"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1),
#"Appended Query" = Table.Combine(Text.ToList(Text.Middle(Text.Repeat(AppIpt, TC01),0,Text.Length(Text.Repeat(AppIpt, TC01))-2))),

in

#"Appended Query"​

<strike></strike>
​

<strike></strike>

TagCount is a variable RowCount.
AppIpt is the text equivalent if I just manually append.

If I put it into a column to see that it is ordered as a list correctly, it exports the text correctly. I am sure there is something I am missing.

I am trying to emulate a select query from a SQL query such as follows:

SELECT TBL1.OBJ1,
TBL2.OBJ1,
TBL1.OBJ2,

TBL2.OBJ1
FROM TBL1, TBL2

I apologize in advance about the formatting... Not sure how to make that work here.

Thank you in advance for any help.​

 

[VBA Geek]

Hi, maybe a visual example?