topic Re: Numeric Sequence in Talend Studio

Numeric Sequence

Anonymous — Tue, 07 Aug 2018 13:16:46 GMT

I have an excel input file with customer names, and I am trying to generate sequence numbers. This is what I am getting right now

CustomerName SequenceGenerated

ABC P1001

ABC P1002

XYZ P1003

But the output I want is as follows:

CustomerName SequenceGenerated

ABC P1001

XYZ P1002

Thanks.

Re: Numeric Sequence

David_Beaty — Tue, 07 Aug 2018 14:24:59 GMT

Hi,

You'll probably need to read in the Customer Name data rows as a pre-step, get the unique customer names, generate the sequence from the unique list, then use tMap, to join the list of unique values and customer name back into the source:

1/ excel -> tuniq -> tJavaRow (generate sequence) -> hash or fileoutput

2/ excel -> tmap (join in hash or file from step one) -> output

Thanks

David

Re: Numeric Sequence

Anonymous — Tue, 07 Aug 2018 14:32:23 GMT

I have just provided sample data, there are multiple customers with same name. Some of the customers have repeated 18 times.

CustomerName

ABC

Re: Numeric Sequence

David_Beaty — Tue, 07 Aug 2018 14:35:52 GMT

Yup, and when you feed those through the tUniqRow, they will get resolved down to one row:

In: A,A,A,A,A,B,B,B,B,B,C,C,D,D,A,,A,B,B,C,D,E

Out: A,B,C,D,E

You then generate the the sequence for these unique names.

Unless I'm completely missing what you're after.

Re: Numeric Sequence

Anonymous — Tue, 07 Aug 2018 14:38:32 GMT

I need those multiple customers with same name listed in the output. I am not looking to get only unique records.

Thanks

Re: Numeric Sequence

David_Beaty — Tue, 07 Aug 2018 14:42:27 GMT

Yup, as per my original reply, step 1 - you get the unique customer names, generate the sequence on those, save into a hash or output file (lets call this unique customer sequences), step 2 - re-read the source data and join in the unique customer sequences.