Hi, I am struggling with joining two indexes based on substring match. I have following indexes : index1 : having following fields PROTOCOL,DIRECTION,FILENAME,DIRECTORYNAME index2: having following fields APPID,CUSTOMERID,FILEPATTERN,DIRECTORYNAME I want to join above indexes based on following condition 1. FILEPATTERN is substring of FILENAME 2. DIRECTORYNAME in index1 = DIRECTORYNAME in index 2. and display output with following fields PROTOCOL,DIRECTION,APPID,CUSTOMERID,FILEPATTERN,DIRECTORYNAME Thanks in anticipation Regards Nikhil
... View more