Filter Table Based on Data in different DB source

[lrose]

@nate_macs

How can I filter or otherwise reference property 3 while using a table bound to a query referencing DB1?

You will have to do the join and filter manually in a script. Or if you are able to, use @pturmel's

Automation Professionals' Integration Toolkit Module

Automation Professionals is pleased to announce the immediately availability of a major upgrade to its free Simulation Aids Integration Toolkit module. The new feature justifying the "major upgrade" language is the implementation of eleven thirty-one new expression functions which use iteration to accomplish complex transforms of datasets and lists, to or from other datasets and lists, applying filtering, ordering, and computed new columns along the way. While there are certain operations that…

to do it in an expression.