Well,
I know my way around most parts of Jet, but I'm stuck a bit now.
Based on a calculation I make in an Excel, I want to generate a certain number of lines.
I know the principle of doing it on an integer table, but it's through an universal connector and I don't have an integer table.
So I can make a list of numbers and use it in my NL:
=NL("Rows";Sheet2!$F$2:$F$11)
But then I don't find a way to "filter"/ limit the number of results, it always returns lines for the entire table.
An easy fix for me would have been the "Limit=" filter, but I can't get that to work either (it just seems to ignore that).
So, can anyone help me? Am I going about this all wrong? My last solution is to create an integer table, but I really hope I can avoid doing that…
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Jan,
The NP has an Integers option. If you combine it with NL you can generate the Rows you need, I guess.
E.g. =NL("Rows";NP("Integers";1;10)) will generate 10 rows numbered from 1 to 10. -
Jet Reports Historic Posts Hi Jan,
That's amazing, never had the need for it because of the integer table. I'll try it out first thing tomorrow morning.
The NP has an Integers option. If you combine it with NL you can generate the Rows you need, I guess.
E.g. =NL("Rows";NP("Integers";1;10)) will generate 10 rows numbered from 1 to 10.
Please sign in to leave a comment.