Difference between tNormalize and tUniqRow

Five Stars

Difference between tNormalize and tUniqRow

Hello Community,

 

Whats the difference between tNormalize and tUniqRow?

I can see in help.talend.com its stated that tNormalize is used to get rid of duplicate row. Can someone help over here?

 

Thanks in advance!

 

Best Regards.


Accepted Solutions
Thirteen Stars

Re: Difference between tNormalize and tUniqRow

tUniqRow - make uniq all data passing thru, but not transform nothing

tNormalize - could do the same, but the main(?) idea - split column by a defined separator

for example:

col1
"1,2,2,3"



would be 

col1
1
2
2
3

or 

col1
1
2
3

 

depending from checkbox - get rid duplicates row

 

-----------

All Replies
Thirteen Stars

Re: Difference between tNormalize and tUniqRow

tUniqRow - make uniq all data passing thru, but not transform nothing

tNormalize - could do the same, but the main(?) idea - split column by a defined separator

for example:

col1
"1,2,2,3"



would be 

col1
1
2
2
3

or 

col1
1
2
3

 

depending from checkbox - get rid duplicates row

 

-----------

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

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