Skip to content

Instantly share code, notes, and snippets.

/gist:6978291
Created Oct 14, 2013

Embed
What would you like to do?
Sessions:
Load
...
upper([Authenticated user]) AS [Authenticated user],
...
FROM $(LogPath)\SESSIONS*.LOG (utf8, txt, delimiter is '\t', embedded labels);
LEFT JOIN (Sessions)
LOAD
'AUSTRIA\' & upper(NT_USER) AS [Authenticated user],
// Vorname & '|' & Nachname as Full_Name
trim(upper(Vorname)) & ' | ' & trim(upper(Nachname)) as Full_Name
FROM
QVD\VWL_User.qvd
(qvd);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.