topic Re: Loop to create table in Developer

Loop to create table

JackSoderstrom — Fri, 10 Sep 2021 17:11:47 GMT

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?

Re: Loop to create table

JackSoderstrom — Fri, 10 Sep 2021 17:30:58 GMT

I think I have to use

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

But does it work with Tables?

Re: Loop to create table

Anonymous — Mon, 13 Sep 2021 10:03:50 GMT

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.