HAVING COUNT. How to get duplicated data from a file ?

One Star

HAVING COUNT. How to get duplicated data from a file ?

Hi everybody,
I want to know if it's possible de simulate a "having count" like in SQL ?

Here is my probleme
I have data in the input (csv file, or xml file) and in this Input I have some data (located in a tag or colum) which can be duplicated and I just want to visualize the duplicated data. Is somebody have an idea about how to do this ?
thanks in advance.
One Star

Re: HAVING COUNT. How to get duplicated data from a file ?

Hi,
use the tUniqueRow component in Data Quality category on the duplicate thread .
Jeremie
One Star

Re: HAVING COUNT. How to get duplicated data from a file ?

Yes it was exactly the component I Need. Thanks a lot ! Smiley Wink

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch