Sum data with same ID

[anjali1]

Hi everyone!

The data in the image shows the Pump Unavailability (%)  for 3 different sites. I need to produce a table which sums the Pump Unavailability (%) for each site.  Eventually I want a table like this:

Site Id:         Pump Unavailability (%)

15553           31.45

15341           164.07

15002          21.39

Unfortunately, the Site Id and Pump Unavailability (%) data is in different tables. I did try to use a join function in the load script to join the tables, but it messed up my data.

Any suggestions on what to do? All help would be appreciated !

[Maria_Halley]

@anjali1 

I will move this to the QlikView app development board.