Well, I probably missed a comma, or have misbalanced parentheses or something. QlikView isn't very good at telling you the real problem, I've found. "Missing/Misplaced FROM", more often than not, means "syntax error in your list of fields".
Ah, looks like I put an EXTRA comma after the last parenthesis in the Elapsed Time line. Remove that comma, or just copy the below.
LOAD
subfield(@1,': ',2) as "Request"
,date(date#(left (subfield(@2,': ',2),8),'YYYYMMDD'),'MM/DD/YY') as "Date"
,time(time#(right(subfield(@2,': ',2),4),'hhmm'),'hh:mm') as "Time"
,interval(subfield(@3,': ',2)/(24*60*60*100),'hh:mm:ss.ff') as "Elapsed time"
,text(subfield(@4,': ',2)) as "User Identifier"
FROM (txt, utf8, explicit labels, delimiter is '|', no quotes)
;
Oh, and perhaps I should explain what this is doing. Hard to learn otherwise.
The subfield() function breaks a field apart into more than one field based on a delimiter, so that's how we're handling the multiple delimiters here - one in subfield, the other in the FROM. We're telling it we want the second subfield and that ': ' is our delimiter, so that should return the value portion.
Date#() and time#() functions build a date or time based on a particular format of the input, so that first string is the format of the input.
Date() and time() functions tell the system how you WANT the date and time to be formatted, so the second string is the format we want.
Interval() tells the system how to format an interval of time. However, now that I look at it, I messed it up. I was assuming that your numbers were hundredths of a second. But an interval is the fraction of an entire day, not of a second, so I should have divided by (24*60*60*100). Fixed.
I explicitly tell it that the User Identifier is text() because we've had some issues in the past with IDs like 043E07 being interpreted as scientific notation, and coming out really weird. So when I see a mixture of text and things that could be interpreted as a number, I wrap it in text() just in case.
