Joining both data with condition

[SH_94]

HI community,

May i know how to use tile tool to join both data below in order to derive the output below?

Thank you.

[Cesc]

Hi, @SH_94 ,

I don't understand the full logic of what you want to do and what conditions. Could you explain a bit more on it?

[binu_acs]

@SH_94 Another tricky one from you😀