Hello. I want to check top row from csv data .
source data is like ;
companyID | companyName| oppotunityID
1 | AAAA | 12345
1 | AAAA | 6789
2 | BBBB | 11111
2 | BBBB | 12346
3 | CC | 22222
and requirement output like this;
flag |companyID | companyName| oppotunityID
* | 1 | AAAA | 12345
| 1 | AAAA | 6789
* | 2 | BBBB | 11111
| 2 | BBBB | 12346
* | 3 | CC | 22222
I want to mark the first line of data for each companyID.
How can we compare the data before and after a line?
Solved! Go to Solution.
I'm using this SQL statement:
"select companyID, max(oppotunityID)
group by companyID"
Mark in tMap and in tDBOutput "Action on data" Update row with new flag.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.