This should be a quick question I hope. I’m just trying to see if there’s a way to query results of a data set internally in toad data point? For example a query modeller result set, querying that to break out data from it, as opposed to exporting that to local storage or sheet/db, whatever and then linking back to that to query that result set? This is a major question that we’ve been asked from newer people in our company using the product and at this point, I dont know of any other way to query data to result sets outside of exporting and then linking and querying that exported data.
Last thing, I notice that when a query modeller file is created (.tsm) it prompts you to save the results. Therefore, I’m not sure where those results are being saved, if they are stored in the .tsm or stored elsewhere, but maybe there’s some way to query the results of the .tsm file somehow?
I just wanted to get confirmation on this before telling others, as well as building lots of processes without knowing if data can be manipulated in toad result sets to run extra operations or queries against that result set that has not been exported.