I want to pull id's from list with a count of 100 one time and there are 40000 id's in list

[Anonymous]

Hi i need a help pulling data with a count of 100 id's from the list of 40000 id's can anyone any query. what chages i have to do in this query .

generatedList = List.Generate(

                    ()=>[i = 0, res = fnGetData(#"TriageItems List"{i})],

                    each [i] < List.Count(#"TriageItems List"),

                    each [i = [i] + 1, res = fnGetData(#"TriageItems List"{i})],

                    each [res]

                  ),

[BA_Pete]

Hi @Anonymous ,

What are you trying to achieve here? Are you just trying to pull a 100-value sample set?

If so, you could do something along these lines:

First, add an [Index] column into your table starting from 1.

Then add this as a filter:

Table.SelectRows(previousStep, each Number.Mod([Index], Table.RowCount(yourTable) / 100) = 0)

Pete

[Anonymous]

i have list of 40000 id's and i have to pull that list in my table but i have to pull that with some iteration one iteration contains [i]=100 id and next iteration [i]=i+100