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 in Talend by james
• 120 points
70 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,470 points
3,332 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,470 points
395 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 16, 2018 in Talend by code.reaper12
• 3,470 points
1,833 views
0 votes
1 answer
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 10, 2018 in Talend by code.reaper12
• 3,470 points
447 views
0 votes
1 answer

Parsing JSON in Talend

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

answered Apr 2, 2018 in Talend by code.reaper12
• 3,470 points
1,220 views
0 votes
1 answer