Reorganize and count data

[Anonymous]

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!

[vapukov · Accepted solution]

You are looking for  - tPivotToColumnsDelimited

https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/x2GUXKMQs_wrCX0kdZDwDg

[Anonymous]

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