Is it possible to Join two named query select statements? Whether in another named query, or in the expression the data parameter of a table?
You can put the two bindings on custom properties, then pass them to a script via runScript() that can produce the merged dataset from the input datasets.
3 Likes
ahh clever I always forget about doing that trick. Thanks again Phil!
Could you put a little more meat on those bones?
I have two named queries ... "A" has a start-time and end-time as parameters, and returns a list of serial and model numbers that were produced during that time, and "B" fetches a list of useful information about each model. They are using different data connections so I can't do the LEFT JOIN natively.
How do I bind the data property of a PowerTable to the result dataset of A LEFT JOIN B on A.ModelNum = B.ModelNum ...
Make some example datasets and post their CSVs here (from the dataset editor popup) in "preformatted text" code blocks. Then I can show you exactly what you need. But note, nowadays I do this exclusively in expressions using my (free) Integration Toolkit module:
https://www.automation-pros.com/toolkit/doc/datasets.html#leftjoin