How to get the uniqe all rows

0 votes

I am new to this one. I want to extract unique rows in a document. In excel we use the filter and select a unique one and we get the unique ones all data. In talent how to get it? I use tuniqrow component but It gives the only one row of the data and other all rows are get rejects! 

sample
file 1 name S1 S2 S3
A a 1 2 3
B b 4 5 7
C c 4 4 4
D d 2 4 1
E e 7 8 9
A a 5 6 9
A a 6 6 4
A a 55 21 1
B b 55 7 66
C c 7 77 7
D d 3 3 3
E e 2 2 2
E e 2 1 1
F f 8 8 8
A a 3 3 3
D d 33 3 3
A a 3 2 1
C c 2 7 8
B b 1 1 1

Here I mention a sample file. Now I use the tuniqrow component to file 1 column I get A, B, C, D, E, F unique. But I want "A" rows all data next "B" rows all data. Where all the "A" rows placed all the data was I want. this one technique we use excel in the help of a filter. Please help! Thank you.

Aug 18, 2020 in Talend by james
• 120 points
741 views

Hi @James,

Regarding your query you have few processes, I would suggest you go through this: https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/URCF4gF0XnGlzPjmIKpLgQ

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Talend

0 votes
1 answer

How to generate multiple rows from a single row in Talend?

I think using tJavaFlex, tMap and tFlowToIterate ...READ MORE

answered Apr 18, 2018 in Talend by code.reaper12
• 3,500 points
7,703 views
0 votes
0 answers

How can I use talend to extract data from Oracle and import the data into a MSSQL database?

We currently have around 100 Oracle tables ...READ MORE

Nov 4, 2020 in Talend by umesh
• 150 points
2,481 views
0 votes
1 answer

Specifying the number of Rows Processed in Talend

Hi, you can try using tSampleRow component ...READ MORE

answered Apr 14, 2018 in Talend by code.reaper12
• 3,500 points
1,802 views
0 votes
1 answer

How to load a set of files into database using Talend

Using tFileList component,  you can read all the files present ...READ MORE

answered Apr 17, 2018 in Talend by code.reaper12
• 3,500 points
6,075 views
0 votes
1 answer
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 11, 2018 in Talend by code.reaper12
• 3,500 points
1,776 views
0 votes
1 answer

Parsing JSON in Talend

While working with JSON files, one thing ...READ MORE

answered Apr 3, 2018 in Talend by code.reaper12
• 3,500 points
3,975 views
+1 vote
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP