ETL and Data Integration tools - Modern ETL software for everyone

Hi,

Here is my task that I am trying to implement.

I have fixed width text file with customer names, addresses and some other fields. Every unique household (which is defined as combination of address and last name field) has household identified, so every record on a file has ID and all the records with the same address and last name of a person have the same ID.

What I need to do is to assign a sequence code starting at 1 for the first record in the group with the same ID, then assign 2 to the second record in the group and etc.

I guess I should sort the data file first by Household ID than assign the sequence number somehow.

Can I do it using one of your ETL tools?

Tim

Using Advanced ETL processor any version

Connect data reader to your text file
Connect Sorter object and add sort data by ID Field
Add data transformer open it and
add sequence transformation function
Double click on Sequence and set Reset Value to
When field changes value

That should do the trick

Mike
PS
Watch our online tutorials to get started