JOIN or COGROUP? - need to join 1 column from first file which should lie in between 2 columns from second file.

[Lakshminarayana Motamarri]

Hi all

I have 2 CSV files a shown below:

*File 1:                     File2:
col1  col2             col1    col2   col3   col4
1234    2                1000   1999
2222    3                2000   2999
3333    5                3000   3999
4444    6                4000   4999*

Now I need to JOIN these 2 files in such a way that:

File1-col1 should lie in between File2-col1 and File2-col2

Can I use JOIN / COGROUP or any other existing operators?

or shud I build a new UDF?

thanks
Narayan.