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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
archienesss
Contributor II
Contributor II
‎2024-11-12 09:53 AM

tFileInputExcel merge and remove duplicate rows

Hello,

May I please ask for your help how I can achieve below data? I am using Talend Studio 8. I am quite familiar with Java and other components like tMap. Thanks in advance!

 

Sample Data:

Name ID Date Start End
SampleName 1 1/1/2024 1/1/2024 1/3/2024
SampleName 1 1/1/2024 1/3/2024 1/5/2024
SampleName 1 1/1/2024 1/5/2024 1/6/2024
SampleName2 2 1/1/2024 1/1/2024 1/3/2024

 

Expected output:

Name ID Date Start End
SampleName 1 1/1/2024 1/1/2024 1/6/2024
SampleName2 2 1/1/2024 1/1/2024 1/3/2024
Labels (2)
Labels
242 Views
0 Replies