topic Re: tNormalize with index or sorting number in Talend Studio

tNormalize with index or sorting number

Anonymous — Tue, 29 May 2018 14:33:58 GMT

-- Info: I noticed that I added this to the wrong board, but it seems I can neither delete this post, nor move it to another board - for whatever reason. Sorry. Could an admin please move this to the correct board? --

Hi Community-members!

I have a very small problem with the tNormalize component, I was not yet able to resolve.

Is there a way to provide some kind of index number of the splitted elements, that tNormalize turns into rows?

Freddy

Re: tNormalize with index or sorting number

vboppudi — Tue, 29 May 2018 14:55:18 GMT

Hi,

If key is unique then you can use key value to generate index value in tMap.

try this : in tMap create variable port index= Numeric.sequence(Key,1,1)

For every key value it will generate sequence.

key | index | value
01 | 1 | value1
01 | 2 | value2
01 | 3 | value3
02 | 1 | value1
02 | 2 | value2
02 | 3 | value3
02 | 4 | value4

Regards,

Re: tNormalize with index or sorting number

Shettydatta — Tue, 29 May 2018 21:35:23 GMT

It works thanks for showing that, Initially I did not get it to work as I was getting index from 1 to XX but then I had not appened my tmap row. to the key

Thanks for sharing

Re: tNormalize with index or sorting number

Anonymous — Wed, 30 May 2018 05:50:35 GMT

Veeru, you are my hero! This is brilliant. Never thought of using the key variable itself as the sequence identifier.

Thank you very much, it works like a charm.

Here is the complete workflow, if someone needs a working example: