Reorganize and count data

Highlighted
Six Stars

Reorganize and count data

Hi! 
I have some data in Excel, in each day there are several alarm records, that is, in the same day several alarms can be generated (even the same alarm several times), the next day some alarms of the previous day and some new ones may appear, and so for several days.

I would like to have a report that tells me for each of the alarms generated, what day (or days) was generated and how many times it was generated on each of those days. The 'date' column (although it looks like 2018-02-22) is in "string" format, just like the alarm column.

I'm using Talend Open Studio for Data Integration, Version: 7.0.1.

Thanks!

 

 

 


Accepted Solutions
Forteen Stars

Re: Reorganize and count data


All Replies
Forteen Stars

Re: Reorganize and count data

Six Stars

Re: Reorganize and count data

Thanks vapukov , I'll try and I'll come back here to tell you if it worked.
Smiley Happy

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read