Identifying Missing server details

[Rajakumaranakash]

I have a table with location and server information. I want to identify the missing server between the site.

My data:

Location	Server
Site A	Server1
Site A	Server2
Site A	Server3
Site A	Server7
Site A	Server5
Site B	Server1
Site B	Server2
Site B	Server3
Site B	Server4
Site B	Server5
Site B	Server6
Site B	server8

Expected output: 

Location	Missing Servers
Site A	Server7
Site B	Server6
Site B	server8

Could some one help me on this?

[Aurelien_Martinez]

Hi,

With this code I can get the good result

Data:
Load
  *
Inline [
Location,	Server
Site A,	Server1
Site A,	Server2
Site A,	Server3
Site A,	Server7
Site A,	Server5
Site B,	Server1
Site B,	Server2
Site B,	Server3
Site B,	Server4
Site B,	Server5
Site B,	Server6
Site B,	server8
];

Join(Data)
Load
  Location as Location2,
  Server
Resident Data
;

Load
  Location,
  Server
Where
  flag
;
Load
  count(Location2) <> FieldValueCount('Location') as flag,
  Location,
  Server
Resident Data
Group By
  Location,
  Server
;

Drop Table Data;

[Rajakumaranakash]

Thank you but I could not modify my script. So I would like to do this with expression. Is there any possible way?

[Aurelien_Martinez]

Okay 🙂

You can try a expression like this:

Count(total<Server> Server) = Count(distinct Location)