topic Re: Identifying Missing server details in App Development

Identifying Missing server details

Rajakumaranakash — Fri, 15 Nov 2024 21:26:31 GMT

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?

Re: Identifying Missing server details

Aurelien_Martinez — Thu, 31 Aug 2023 13:27:33 GMT

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;

Re: Identifying Missing server details

Rajakumaranakash — Thu, 31 Aug 2023 15:21:06 GMT

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

Re: Identifying Missing server details

Aurelien_Martinez — Thu, 31 Aug 2023 15:30:50 GMT

Okay 🙂

You can try a expression like this:

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