
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use Group by base on TGB_Name
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
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the reply

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If your issue resolve please close thread.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

- « Previous Replies
-
- 1
- 2
- Next Replies »