Generate List Using Specify Number

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

Nope.

Hokay. Thanks much for replying

1 Like

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

Excellent idea!

2 Likes

Related feature request:

2 Likes