Data Load from excel and filteration

[#1]

Hi

I am loading data directly from excel which are having many columns. Sample format of the data is below

Now I need to summarize the data information from this loaded table.  The summarized data should contain one row value for a specified date having max value for the column power.

ie for 11/10 the i need the 3rd row (4225) of the data and for 10/10 the selected row will be the last ( 4230)

Appreciate your help in creating a load script to achieve this in qlik sense..  I am a beginner in using this application.

Regards

[Gysbert_Wassenaar]

You can create a flag field in the script by joining the table with a summary table:

Table1:

LOAD * FROM ...excel_file...;

JOIN (Table1)

LOAD

     [Date/Time],

     VILLA_ID,

     Max(Power) as Power,

     1 as IsMaxPowerRecord

RESIDENT

     Table1

GROUP BY

     [Date/Time],

     VILLA_ID

     ;

You can then use the new field IsMaxPowerRecord (or whatever you decide to us as field name) to filter the data.