Custom Transformer: FeatureCrossJoiner

It might be nice to adapt so that you could choose between a full cross join, i.e permutations, or combinations

Create a table with all possible pairings of numeric values from input table. | Community

You can use the InlineQuerier to do cross joins out of the box:

david_r wrote:

You can use the InlineQuerier to do cross joins out of the box:

 

The FeatureJoiner method gives you a few more options for handling geometries. It’s also needed if you’ve self imposed a rule of no python or inlinequeriers when doing advent of code :-)

ebygomm wrote:

david_r wrote:

You can use the InlineQuerier to do cross joins out of the box:

 

The FeatureJoiner method gives you a few more options for handling geometries. It’s also needed if you’ve self imposed a rule of no python or inlinequeriers when doing advent of code :-)

It’s difficult to argue against self-imposed restrictions ;-)

Yup, and similarly use InlineQuerier for exactly that. 😉   I get the impression though that in the Community that there is a mix of just not knowing about InlineQuerier for alternative SQL methods, or they find writing the SQL daunting, or maybe be lazy like me and just want a workspace shortcut to just quickly pop 1 x Transformer onto the workspace, connect 2 x connectors and not have to write anything else 😉

Plus as ​@ebygomm notes, FeatureJoiner has thing like automatically putting the Schema back into Bulk Mode, it can be faster in a lot of circumstances too if the upstream Features are in Bulk Mode and can Aggregate the Left/Right Geometry.  But yes, I use both for Cross Joins depending on circumstances.

Again, nothing earth-shattering:just something to be able to avoid a couple of AttributeCreators and an AttributeRemover, and an alternative to point users to with the occasional Cross Join questions that come up.