This content has been marked as final. Show 3 replies
I'm not sure if this will work - you may need to load the data into a qvd file first - but you should be able to do this using Join.
Distinct If (SEQUENCENO=0, ENQUIRYID) As Enquiry,
If (SEQUENCENO=0, TIMESTARTED) As "LOGDATE";
Distinct If (SEQUENCENO=1, ENQUIRYID) As Enquiry,
If (SEQUENCENO=1, TIMESTARTED) As "FOLLOWUPDATE";
This should join the data on the (matching) Enquiry field.