How do I match 2 timetables via a Left Join (outerjoin)

and where the date may not exist on the right timetable , I would like to find the nearest date greater than the one that doesn't exist.

I'm aware of synchronise which performs a linear interpolation - essentially , I'd like the equiv of find(X >= y , 1 , 'first') for each date

Thanks

Answer 1

[Cris LaPierre]

I would recommend using the Join Tables Live Task to perform your join interactively. Once you find the settings that get you the result you want, you can convert the task to code.

Otherwise, please attach your data using the paperclip icon, as well as an example of what the output should be.

[Eric Sofen]

As Chris said, it helps to see the data and an example of the desired output. But from your description, does synchronize(A,B,"first","previous") do the trick?

[Zafrul Bhuia]

Hey Eric , didn't see the 'first' , 'previous' in the documentation .. is that new? I'll try it .. Thanks