Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I've got 2 tables:
TAB1:
IND_DT_POCZ_ZATR | IND_DT_KONC_ZATR | IND_KLUCZ_ZAT | IND_PRC_NUMER | IND_STATUS | IND_ZAT_FRM_ID |
1996-01-02 01:00 | 2006-12-31 01:00 | 2385#35066#1 | 2385 | 1 | 1 |
2008-07-16 02:00 | 2010-01-31 01:00 | 2385#39645#1 | 2385 | 1 | 1 |
2018-11-30 01:00 | 2385#43434#1 | 2385 | 1 | 1 | |
2385#UMC | 2385 | 0 | 1 |
TAB2:
AB_DATA_OD | AB_ID | IND_PRC_NUMER |
1997-01-02 01:00 | 1202499 | 2385 |
2004-07-19 02:00 | 841388 | 2385 |
2006-08-14 02:00 | 1242905 | 2385 |
2009-11-01 01:00 | 1339365 | 2385 |
2019-03-04 01:00 | 1561688 | 2385 |
DESTINATION TABLE:
AB_DATA_OD | AB_ID | IND_PRC_NUMER | IND_KLUCZ_ZAT |
1997-01-02 01:00 | 1202499 | 2385 | 2385#35066#1 |
2004-07-19 02:00 | 841388 | 2385 | 2385#35066#1 |
2006-08-14 02:00 | 1242905 | 2385 | 2385#35066#1 |
2009-11-01 01:00 | 1339365 | 2385 | 2385#39645#1 |
2019-03-04 01:00 | 1561688 | 2385 | 2385#43434#1 |
I try script:
TAB3:
IntervalMatch("AB_DATA_OD",IND_PRC_NUMER)
LOAD
IND_DT_POCZ_ZATR,
IND_DT_KONC_ZATR,
IND_PRC_NUMER
Resident TAB1 where IND_STATUS=1;
inner Join(TAB2)
LOAD
IND_PRC_NUMER,
IND_DT_POCZ_ZATR
Resident TAB3;
but results are:
AB_DATA_OD | AB_ID | IND_PRC_NUMER | IND_KLUCZ_ZAT |
1997-01-02 01:00 | 1202499 | 2385 | 2385#35066#1 |
1997-01-02 01:00 | 1202499 | 2385 | 2385#43434#1 |
2004-07-19 02:00 | 841388 | 2385 | 2385#35066#1 |
2004-07-19 02:00 | 841388 | 2385 | 2385#43434#1 |
2006-08-14 02:00 | 1242905 | 2385 | 2385#35066#1 |
2006-08-14 02:00 | 1242905 | 2385 | 2385#43434#1 |
2009-11-01 01:00 | 1339365 | 2385 | 2385#35066#1 |
2009-11-01 01:00 | 1339365 | 2385 | 2385#43434#1 |
2019-03-04 01:00 | 1561688 | 2385 | 2385#35066#1 |
2019-03-04 01:00 | 1561688 | 2385 | 2385#43434#1 |
Any help will be appreciated 🙂
Regards
please check the attached