Is there a way to join two tables using the between operator (SQL). I know I can use SQLCreator but I would like to do this join directly in workbench.
sql example:
TABLE1.*,
TABLE2.*
FROM TABLE1
LEFT JOIN TABLE2
ON TABLE1.NAME = TABLE2.NAME AND TABLE1.DATE BETWEEN TABLE2.FROM AND TABLE2.TO
Hi
let me know if this helps or if you have further questions!
For your join clause you can rewrite it to:
ON TABLE1.NAME = TABLE2.NAME
AND TABLE1.DATE >= TABLE2.FROM
AND TABLE1.DATE <= TABLE2.TO
Since you don’t want to do it in SQL with an InlineQuerier and do it entirely in workbench transformers, your best bet is the custom transformer FeatureRangeMerger.