Generate List Using Specify Number

[WilsonWee]

Hi guys,

Is there an expression to allow me to generate a list of numbers by specifying a number from another column?

Example:
Column_A = 10
List= [1,2,3,4,5,6,7,8,9,10]

I know i can use IF() but i wonder if there is a more elegant way? Even nicer if we can concatenate “OP”"[Column_A]".

Thanks

[Steve]

WilsonWee:

Is there an expression to allow me to generate a list of numbers by specifying a number from another column?

Nope.

[WilsonWee]

Hokay. Thanks much for replying

[Stelio_Pappas]

Hi @WilsonWee, did you end up with a work around for this?

I have encountered the same scenario. My number range is not very large, so I’m thinking of making a table with the numbers 1 to 100 and then doing a SELECT(to produce a list of all numbers lower than the one in my other column).

Was your solution more elegant?

Stel

[Steve]

Stelio_Pappas:

I’m thinking of making a table with the numbers 1 to 100 and then doing a SELECT

Excellent idea!

[Marc_Dillon]

Related feature request:

List Generator Expressions Feature Requests

NUMBERLIST(0,10) = {0,1,2,3,4,5,6,7,8,9,10} DATELIST(TODAY() , TODAY()+7) = {2/3/21 , 2/4/21,… , 2/10/21} ALPHALIST(“a” , “d”) = {“a” , “b” , “c” , “d”} DECIMALLIST(0,0.5,0.1) = {0,0.1,0.2,0.3,0.4,0.5}