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.