Map two tables within a time range

[anguslou]

I am going to map a Payment ID with Potential IP by +/- 5 minutes of Transaction Time:

Table A:
Transaction Time Payment ID
2020-1-17T13:45 123456
2020-1-18T05:23 234567

Table B:
Record Time IP
2020-1-17T13:42 150.135.23.1
2020-1-17T13:46 171.234.67.34
2020-1-18T05:25 113.565.34.27
2020-1-18T05:26 170.78.343.27

So that:
Transaction Time Payment ID IP
2020-1-17T13:45 123456 150.135.23.1|171.234.67.34
2020-1-18T05:23 234567 113.565.34.27|170.78.343.27

What should I do for this please?

[HansS]

Hi @anguslou

Have you seen this forum post Join date by range.
gr. Hans

[anguslou]

Hi HansS,

Thanks for your prompt reply. I am thinking something similar but don’t know how to make it in KNIME. I didn’t use streaming before but like to give it a try.

Thanks again.

Angus

[ipazin]

Hi @anguslou,

streaming is only to process data faster. If you are satisfied with your execution time you can skip streaming functionality…

Br,
Ivan

[anguslou]

Got it, I will try to build the loop first.

[anguslou]

It works perfectly as expected, thank you.