if(len(trim(ID_Orig))=0, if(Phone=peek(Phone),If(CALL_ID>peek(CALL_ID),peek(ID_Orig))),ID_Orig) as ID
But, it doesnt work. Any thoughts?
Also, the original code works only if there is a single Inbound/Outbound record for a matching Manual call phone number. It fails when it has to look up at multiple Inbound/Outbound records to fill the missing ID on Manual record
I couldnt open the qvw as I use Qlik Sense Server.
Could you take a look at the attached Input2 file? I'm unable to generate ID for the last row in the data set(ID has to be 4). Sorry for not mentioning the full characteristics of the original data set earlier.