ETL and Data Integration tools - Modern ETL software for everyone

Hello,

Finally I am working on my first "real" data transformation, meaning I've done a lots of practising with dummy data and I have watched all online tutorials.

I have extracted data from a text file - each row is a 'snapshot' of a support ticket at a given time. I need to toss the older snapshots and retain the newest.

for example; 'ticket_number' is my problem ticket field; and 'page' is the snapshot.
ticket_number is a text field, page is a number. 'page' does NOT contain duplicates, ticket_number may have some duplicates. so

For example:

ticket_number,page
TN760162,001
TN760162,002

I want to get rid of the first row, but I can't really figure out how.

Any assistance is appreciated!

Ron

Ok

What you need to do is sort your data first.
Than use data grouper as on the picture attached.
This should give you the desired result.

Best regards,
Mike