what is '@1' in query?

[#1]

Hi,

I am trying to understand script developed by someone else.. While reading, I see some '@1' symbol, what is means?

In the query we are fetching data from log which contains details as username, which user downloaded which report, when etc?

FileDownload:

LOAD Timestamp#(Subfield(SubField(@1, '-',2),'.',1), 'MM/DD/YYYY hh:mm:ss') AS "Download DateTime",

date((Subfield((Subfield(SubField(@1, '-',2),'.',1)), ' ', 1)), 'DD/MM/YYYY') as "CalendarDate",

Trim(Upper(Subfield(SubField(@2,'<UserId>',2),'</UserId>',1))) as User,

Subfield(SubField(@2,'<Path>',2),'</Path>',1) as Document_Dummy,RecNo() as NoOfRows

FROM

(txt, codepage is 1252, no labels, delimiter is '\t', msq, filters(

Remove(Col, Pos(Top, 2))

))

WHERE(Left(@2,23) <> 'Request received [GET]:')

and (Left(@2,18) <> '<Global><_retval_>')

and not isnull(Trim(Upper(Subfield(SubField(@2,'<UserId>',2),'</UserId>',1))))

and Trim(Upper(Subfield(SubField(@2,'<UserId>',2),'</UserId>',1))) <> ''

;

can someone explain me?

BR,

Anta

[swuehl]

You address your data columns using @1, @2.

Since you are loading your text file in with 'no labels' attribute, you need to address your data columns in such way.

[#3]

Hi Swuehi,

I am not able to see data after 22 Mar 2013.

BR,

Anta

[#4]

LOG FILE DETAILS:

\\SERVER\C$\ProgramData\QlikTech\WebServer\Log\20130502.txt:5/2/2013 09:50:42.3904326     Information       Request received [GET]: http://SERVER_NAME/QvAJAXZfc/AccessPoint.aspx?open=&id=localhost|Registered Users.qvw&client=Download

\\SERVER_NAME\C$\ProgramData\QlikTech\WebServer\Log\20130502.txt-5/2/2013 09:50:42.3904326      Information            <Global method="GetUtilizationData"></Global>

\\SERVER_NAME\C$\ProgramData\QlikTech\WebServer\Log\20130502.txt-5/2/2013 09:50:42.3904326      Information            <Global><UtilizationData>

<GBytesOfRamConfigured>179.192982483</GBytesOfRamConfigured><NumberOfCores>32</NumberOfCores><RecentCpuPercent>0</RecentCpuPercent>

<RecentRamOverload>0</RecentRamOverload><OffDuty>false</OffDuty><Unlicensed>false</Unlicensed></UtilizationData></Global>

\\SERVER_NAME\C$\ProgramData\QlikTech\WebServer\Log\20130502.txt-5/2/2013 09:50:42.3904326      Information            LoadBalancing

\\SERVER_NAME\C$\ProgramData\QlikTech\WebServer\Log\20130502.txt-5/2/2013 09:50:42.3904326      Information            LoadBalancing - selected Qvs: localhost

\\SERVER_NAME\C$\ProgramData\QlikTech\WebServer\Log\20130502.txt-5/2/2013 09:50:42.3904326      Information            <Global method="GetTicket"><UserId>DOMAIN_NAME\USER_NAME</UserId><GroupList><string>S-1-5-21-1593251271-2640304127-1825641215-513</string><string>S-1-1-0</string><string>S-1-5-32-545</string><string>S-1-5-2</string><string>S-1-5-11</string><string>S-1-5-15</string><string>S-1-5-21-1593251271-2640304127-1825641215-368858</string><string>S-1-5-21-1593251271-2640304127-1825641215-857330</string><string>S-1-5-21-1593251271-2640304127-1825641215-852205</string><string>S-1-5-21-1593251271-2640304127-1825641215-1551228</string><string>S-1-5-21-1593251271-2640304127-1825641215-1338026</string><string>S-1-5-21-1593251271-2640304127-1825641215-835550</string><string>S-1-5-21-1593251271-2640304127-1825641215-1257998</string><string>S-1-5-21-1593251271-2640304127-1825641215-769520</string><string>S-1-5-21-1593251271-2640304127-1825641215-1136094</string><string>S-1-5-21-1593251271-2640304127-1825641215-1387499</string><string>S-1-5-21-1593251271-2640304127-1825641215-1467662</string><string>S-1-5-21-1593251271-2640304127-1825641215-833490</string><string>S-1-5-21-1593251271-2640304127-1825641215-869802</string><string>S-1-5-21-1593251271-2640304127-1825641215-1258003</string><string>S-1-5-21-1593251271-2640304127-1825641215-1371924</string><string>S-1-5-21-1593251271-2640304127-1825641215-1350927</string><string>S-1-5-21-1593251271-2640304127-1825641215-910431</string><string>S-1-5-21-1593251271-2640304127-1825641215-1258004</string><string>S-1-5-21-1593251271-2640304127-1825641215-875472</string><string>S-1-5-21-1593251271-2640304127-1825641215-1237487</string><string>S-1-5-21-1593251271-2640304127-1825641215-833488</string><string>S-1-5-21-1593251271-2640304127-1825641215-769519</string><string>S-1-5-21-1593251271-2640304127-1825641215-1539412</string><string>S-1-5-21-1593251271-2640304127-1825641215-1198349</string><string>S-1-5-21-1593251271-2640304127-1825641215-1387502</string><string>S-1-5-21-1593251271-2640304127-1825641215-948578</string><string>S-1-5-21-1593251271-2640304127-1825641215-796110</string><string>S-1-5-21-1593251271-2640304127-1825641215-1415192</string><string>S-1-5-21-1593251271-2640304127-1825641215-638037</string><string>S-1-5-21-1593251271-2640304127-1825641215-1087635</string><string>S-1-5-21-1593251271-2640304127-1825641215-210282</string><string>S-1-5-21-1593251271-2640304127-1825641215-1539415</string><string>S-1-5-21-1593251271-2640304127-1825641215-869801</string><string>S-1-5-21-1593251271-2640304127-1825641215-1467651</string><string>S-1-5-21-1593251271-2640304127-1825641215-356796</string><string>S-1-5-21-1593251271-2640304127-1825641215-1341561</string><string>S-1-5-21-1593251271-2640304127-1825641215-769494</string><string>S-1-5-21-1593251271-2640304127-1825641215-342871</string><string>S-1-5-21-1593251271-2640304127-1825641215-833486</string><string>S-1-5-21-1593251271-2640304127-1825641215-835549</string><string>S-1-5-21-1593251271-2640304127-1825641215-409900</string><string>S-1-5-21-1593251271-2640304127-1825641215-258763</string><string>S-1-5-21-1593251271-2640304127-1825641215-659616</string><string>S-1-5-21-1593251271-2640304127-1825641215-1368604</string><string>S-1-5-21-1593251271-2640304127-1825641215-659619</string><string>S-1-5-21-1593251271-2640304127-1825641215-1211007</string><string>S-1-5-21-1593251271-2640304127-1825641215-978479</string><string>S-1-5-64-10</string></GroupList><GroupListIsNames>false</GroupListIsNames></Global>

--

HERE, Name of the applications is Registered users.qvw, User Name is DOMAIN_NAME\USER_NAME.