Join two tables on interval of dates

Hi.
We are trying to find the best way to join two tables (A and B) with a join condition that requires to match a date (in table A) between two dates (in table B).
We saw that the joiner node does not allow to match columns in other way than exact match.
We cannot use cross / cartesian joins because the two tables are quite big in volume.
Could you suggest a solution, please?
Thanks a lot for you help.

Cristina

1 Like

Hi @cristina_piussi

First thing that comes to mind to eliminate the issue with the cross join on row volumes would be to loop through the dates in the master table, then do the cross join?

This might be slow depending on the number of dates

Thanks,

Matt

Hello @cristina_piussi,

check out this topic:

Option missing there seems to be Cross Joiner + Rule-based Row Filter in streaming mode.

Br,
Ivan

2 Likes

I think your solution with the dictionary binner should work right? Have done this in the past as well using this node but forgot about it so thanks for reminding me

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.