Use Group by base on TGB_Name

[iahmadmca1]

Team,

Just I want to take one help regarding group by TGB Name.I have listed down the below script based on this script I need to use group by TGB_Name could you please help me to do this.

Details:

LOAD OperatingDate as oprating_date,

      TGB_ID as TGBID,

     TGB_Name as TGBName,

     ENCLOSURE as Enclosure,

     ALARMS as Alarm,

     IPADDR as IPAddress,

     FIRST_ALERT as First_Alert,

     LATEST_ALERT as Latest_Alert,

     COUNTER as Counter,

     EVENT_TIME as Event_time

       FROM

(qvd) ;

Below TGB Name details.

TGB_Name
Elkview_DA (PECO_AC PECOD) Newlinville_DA (PECO_AC PECOD) Pools_DA (PECO_AC PECOD) Elkview_AMI (PECO) Newlinville_AMI (PECO) Pools_AMI (PECO) METER_SHOP_1733_TEST (PECOTEST) BerwynMeterShop_AMI_TX2 (PECO)

Thanks,

Irshad Ahmad

[iahmadmca1]

Thanks for the reply

[PrashantSangle]

If your issue resolve please close thread.