Qlik Community

Ask a Question

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

NSLOOKUP

I am trying to do NSLOOKUP and get the server information back.It works but it replies only first two rows of the result.

Please let me know if there is any error in the code??

sub nslookup()

set TableBox = ActiveDocument.GetSheetObject( "TB02" )
for rij = 1 to TableBox.GetRowCount-1
cell = TableBox.GetCell(rij,0).text
Set objShell = CreateObject("WScript.Shell")
Set objExec = objShell.Exec("nslookup -n 2" & cell)
strPingResults = LCase(objExec.StdOut.ReadAll)
TableBox.SetInputFieldCell rij-1,3,strPingResults
'msgbox(strPingResults)

next
end sub

REGARDS

Priya

0 Replies