Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tUniqrow: Sending all duplicate rows to Duplicates destination

I am attempting to use a tUniqRow transform for its intended purpose -- row deduplication. However, tUniqRow sends the "First" duplicate row to the Uniques output path and each subsequent duplicate row to the Duplicates output path.
The requirements for my current project dictate that ALL rows which match one another (based on defined keys) are passed to the Duplicates output path and only rows which are truly unique be passed to the Uniques path.
To comply with this requirement, I am attempting to outer join (via tMap or tFuzzyMatch) the Uniques output with the Duplicates output from the same tUniqRow transform. However, Talend does not allow me to connect the two data paths from tUniqRow ? even when those paths are ?interrupted? by another transform. The designer refuses to connect the 2nd (lookup) row path to the tMap or tFuzzyMatch component.
The described section of this job is designed as follows:
         --> tSortRow  -->
tUniqRow tMap or tFuzzyMatch
--> tSortRow -->

Is this a bug or is there an inherent reason why the Uniques and Duplicates data streams can?t be connected?
Labels (2)
12 Replies
Anonymous
Not applicable
Author

Hi moinerus
Can you please add the issue number here? It will be convenient and helpful for others to trace and monitor the issue you have reported.
Shong
Anonymous
Not applicable
Author

TDI-28405 tUniqRow returns first duplicate for uniques and not all duplicates for duplicates
Anonymous
Not applicable
Author

hi folks , can any one help > Need use tUniqRow I have no Ideia  .. Need to do exactly what is show bellow .. 
Name, Address
John Smith, 111 Main Street
Bob Dole, 1234 Pine Street
John Smith, 111 Main Street

The tUniqRow component processes this file as follows:
--Uniques--
John Smith, 111 Main Street
Bob Dole, 1234 Pine Street

--Duplicates--
John Smith, 111 Main Street

Tks for your time
Rgs