I happened to see the Interval Match with extended Syntax by the reply you have posted, so I just went and read about it in help and did a small check, I happen to see that Interval Match with extended Syntax does not give any synthetic keys unlike the usual Interval Match. Could you please explain the reason behind it. The script that I have used is as below:
Thanks All for your inputs - was not using appropriate keys to join earlier.
TRADEDETAILS: LOAD date(TRADE_DT) as TRADE_DT, ACCTID, TRADE_PROFIT FROM (ooxml, embedded labels, table is TradeDetails);
MANAGER: LOAD date(MGR_START_DATE) as MGR_START_DATE, date(MGR_END_DATE) as MGR_END_DATE, ACCTID, MGR, MGR_DESC, autonumber(ACCTID & date(MGR_START_DATE) & date(MGR_END_DATE)) as Key FROM (ooxml, embedded labels, table is ManageDetails);