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
Solved! Go to Solution.
Can you provide sample input data, and desired output?
You'll likely need to use the Generate Rows tool.
Chris
Hi Chris
I've added the input output in my original post.
Thanks for your help
Regards,
Damiano
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.
Thanks Neil
That's very helpful.
Do you know whether is possible to do something similar using characters rather than numbers?
Regards,
Damiano