how to create a sequence code for a group of records with the same id
Hello,
here is my task that I am trying to implement in talend.
I have fixed width text file with consumer names, addresses and some other fields. Every unique household (which is defined as combination of address and last name field) has household identified (HHID), so every record on a file has HHID and all the records with the same address and last name of a person have the same HHID.
What I need to do is to assign a sequence code starting at 1 for the first record in the group with the same HHID, then assign 2 to the second record in the group and etc.
My understanding that I should sort the data file first by HHID, when using calculate do a group by, but I am puzzled how to get down back on a record level and generate the sequence.
I want to thank you all again for their input and help (especially emaxt6 and gatigossou) - you are great community and I truly believe that talend will become a leading product not only in open source world but also as a commercial product. I see its tremendous potential and I would definitely check back again to see the future versions
hi people!!!
i'm experiencing this error and i'm strugling to fix it:
Exception in component tMysqlOutput_1
java.lang.NullPointerException
at demoTest.extract_job1_0_1.Extract_Job1.tFileInputDelimited_1Process(Extract_Job1.java:2763)
at demoTest.extract_job1_0_1.Extract_Job1.runJobInTOS(Extract_Job1.java:4727)
at demoTest.extract_job1_0_1.Extract_Job1.main(Extract_Job1.java:4620)
tFileInputDelimited->tmap->tMysqlOutput
can you please guys help.
Hello everyone is it posible to extract information from a csv file into a MySQL table. if possible how? using a tmap. your assitance will be appreciated. thanks
Hello Everyone,
I need assistance, I have a job that read files from a defined directory and in this directory we have list of filenames which are uniquely identified by their sequence which is part of the file name of each file. What i want to do is to monitor the sequence of these files as i'm reading them from the source and if the are gaps in the file sequnce i must be able to get an alert about this or an identification and an the example of a file name is file_00001_20110112123515
please guys i would love to get help on this subject
Cheers
