Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
iam using with numerics its work fine but dates wise iam not get correct result,please explain
hi,
use interval match with date format or numeric format of date because it compares the date then give result.
may be you date in string format show that interval match not working.
i will suggest you use interval match with numeric date or date like num(DATE) (it will run fast).
Regards
Vimlesh
May be your date field’s not proper format. First you can convert all field in one format then you can try.
ya thanks for quick reply my dear friend...i know how to use of interval match between numerics but without converting the num format of dates is it possible...like ABC table is there which contains
ABC:
load mindate,maxdate,ename
01/05/15,20/05/15,srinu
01/04/2014,20/04/2014,pratap
02/03/2013,10/03/2013,venkat
XYZ:
load date,dept
15/05/15,sales
21/04/2014,production
02/03/2013,clerk
bridge:
interval match(date)
load mindate,maxdate resident ABC;
without converting dates into num is it possible?
No it is not possible
ABC:
load Date#(mindate,'DD/MM/YYYY') As mindate,Date#(maxdate,'DD/MM/YYYY') As maxdate,ename Inline [
mindate,maxdate,ename
01/05/15,20/05/15,srinu
01/04/2014,20/04/2014,pratap
02/03/2013,10/03/2013,venkat ];
XYZ:
load Date#(date,'DD/MM/YYYY') As date,dept Inline [
date,dept
15/05/15,sales
21/04/2014,production
02/03/2013,clerk];
bridge:
IntervalMatch(date)
load mindate,maxdate resident ABC;