Hi All,
I am looking for a way to dynamically select rows from a XYDB file. I don't think I am able to do it using the dynamic Input tool.
Any other solution that does not require the use of macros?
Thanks a lot!
Hi @Luca
There's no way to read only a portion of .yxdb file. Any input reads the whole file. Unless you have millions of rows in the file or you're short on RAM, the read-and-join technique that you show is the way to go. In any case, if there was some way to filter the results on read, it would take at least the same amount of time since a logical "Join" would be performed while reading the file. The only benefit would be less RAM used once the file was read.
Dan
What exactly do you mean by dynamically selecting rows?
If you want to select a specific range of rows you could use the Filter or Select Records tools.
It depends on what you're trying to achieve.
Consider a scenario like the above.
I am trying to avoid pulling the entire XYDB file and then using the join tool. I would like to retrieve only the rows associated to the order list file.
