talend
How to count identical rows?
I have rows with years in a csv file as follows:
2009
2010
2010
After processing them, I want an output as follows:
2009:1
2010:2
How do I get the number of identical rows?
Solution
Well, I got the answer in taggregaterow. I created duplicate rows and then grouped using one and counted the other.
I duplicated the year rows into year1 and year2. Then I selected the option in the following
- Talend BatchUpdateException not caught while using tOracleOutput
- How to parse NDJSON
- BigDecimal division throwing ArithmeticException: Division by zero even when i check against it
- Talend - Send HTTP POST Request with form-data
- How to display Talend tDbRow output?
- Using tHttpRequest to download an Excel File from Sharepoint with Authentication
- How to apply a row limit based on percentage filtration in Talend?
- Using Query_sm (Smpp)
- Unable to use both SQL Server and Postgres connection together on the same job - Talend
- How can I convert local time to UTC and vice versa in a Talend job
- Talend : How to fix the code of method is exceeding the 65535 byte limit
- Extracting more than 25 rows from REST API using tRest and tExtractJSONFields
- Get Count from tRest in Talend
- Retrieving the last set of inserted rows?
- How to fix Java heap space error in Talend?
- Talend Open Studio (6.5.1) tMap join with <= / >= condition
- tmap talend NullPointerException
- how to create a HTML-Table in Email with input of Database query
- Talend - tSystem error after deployment on the TMC
- Talend Open Studio encoding issue
- Talend Open Studio (TOS) / eclipse IDE: Perspectives not saved / Can't keep customised perspectives
- How to expose mysql data as a soap web service in Talend
- Extract data from array/list with tExtractJsonFields in talend DI 7.2
- Talend ESB Runtime SERVER
- How to do error handling with tFileInputExcel
- database migrated with talend big data but there is a jump on id
- How to extract array fields from json field (mongodb) with 'textractjsonfield' and why rows are passed but not showed in the 'tlog'
- using tFTPConnection to connect to SFTP using a public key file without passphrase
- Talend Using Custom SQL Template
- Pass dynamic value type Date into tSOAP Message