topic Re: Issue with Resident Load ? in QlikView

Issue with Resident Load ?

Pulkit_Thukral — Mon, 31 Aug 2015 06:30:49 GMT

Facing an issue in combining more than 2 tables using resident load .

It is showing junk values for each field in the straight table .

Attaching the model and selecting the device that should have value 0 for all distinct services(5) at 8/6/2015 17:10 . But it is showing the value as 0 for the other timestamp as well and along with that it is having junk value for Value 0 and 1 Both .

Basically the final output here should be having 10 rows here with 1 selected device - 5 rows with timestamp 8/6/2015 17:10 and all 5 services values set to 0 based on the source

AND 5 rows with timestamp 8/6/2015 1:10 and all 5 services values set to 1.

Re: Issue with Resident Load ?

tripatirao — Mon, 31 Aug 2015 07:02:40 GMT

Please try this

ADAvailabilityData2:

LOAD

//[SERVER NAME] ,

if(Lower(STATUS) <> 'running',0,1) as ADAvailStatus

Resident Table1 where [SERVICE NAME] ='Active Directory Domain Services';

Re: Issue with Resident Load ?

pokassov — Mon, 31 Aug 2015 07:11:41 GMT

Hi!

1. You won't find Table2 because Table2 has concatenated with Tables2 cause it has the same fields.

2. You check status only for one service "Active Dire4ctory Domain Services" for Server.

3. It looks like some rows in Table1 or Table2 have status='Stopped' for service name "Active Dire4ctory Domain Services"