Create an Array of x rows and apply an if to the array

DS80845

Hi there

Below what I'm trying to achieve:

1)I have a higher and lower number

S2 H e.g. 4110899

S2 L e.g. 4110000

2)The above two numbers represent a range from  4110000 to 4110899

the variable let's call it "asize"=S2 H - S2L which equals to: 4110899 - 4110000=899

3) I want to create an array of 899 rows which includes {4110000 (1st row in the array), 4110001.....4110898 (last row in the array)}

4) Finally I want to check if a specific number let's say 4110050 is within the created array, if true return 1 or "TRUE". In the example above this will return "TRUE".

Hope the above is clear enough. Please let me know if you require more details.

*Attached an Input/Output file

Thanks in advance for your help

Regards,

Damiano

InputOutput_070820.xlsx

neilgallen

see attached example. The generate rows tool creates a record for every value between your two limits. Then you join to a different input with your target number. If the "J" anchor has any records, then your condition is true.

You could make this a bit more interactive with messaging tools or even as an analytic app where the user can identify the limits and target numbers, etc.

number array.yxmd