Loop to create table

[JackSoderstrom]

Making a custom navigation table. How would I have a loop to create this?

let

        ColumnNames = Table.ColumnNames(DatabaseRecords(num)),

        objects = #table(
            {"Name",         "Key",   "Data",                                                    "ItemKind", "ItemName", "IsLeaf"},{

            {ColumnNames{0}, ColumnNames{0}, Table.Column(DatabaseRecords(num), ColumnNames{0}), "Table",    "Table",    true},
            {ColumnNames{1}, ColumnNames{1}, Table.Column(DatabaseRecords(num), ColumnNames{1}), "Table",    "Table",    true},
            {ColumnNames{2}, ColumnNames{2}, Table.Column(DatabaseRecords(num), ColumnNames{2}), "Table",    "Table",    true},
            {ColumnNames{3}, ColumnNames{3}, Table.Column(DatabaseRecords(num), ColumnNames{3}), "Table",    "Table",    true},
            {ColumnNames{4}, ColumnNames{4}, Table.Column(DatabaseRecords(num), ColumnNames{4}), "Table",    "Table",    true},
            {ColumnNames{5}, ColumnNames{5}, Table.Column(DatabaseRecords(num), ColumnNames{5}), "Table",    "Table",    true},

Right now its hard coded to iterate through. I want a loop that goes through 0-5 to create these. Do I utilize list.genertate? if so how?

[Anonymous]

Hi @JackSoderstrom 

Could you show me your DatabaseRecords(num) Table? Or you can share a easy sample which was got data by enter data. You can show me a screenshot that you the result you want. This will make it easier for me to know your requirement. 

Here is a Offical blog for List.Accumulate function.

For reference: List.Accumulate

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JackSoderstrom]

I think I have to use 

List.Accumulate({1, 2, 3, 4, 5}, 0, (state, current) => state + current),

But does it work with Tables?