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
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!
Related feature request:
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |