topic Re: Count index values in Talend Studio

Count index values

Anonymous — Sat, 16 Nov 2024 04:13:18 GMT

my input is like

id,col1,col2,col3

101,a,b,a

102,a,a,a

103,b,a,b

My output should be like

101,1,a

101,2,b

101,3,a

102,1,a

102,2,a

102,3,a

103,1,b

103,2,a

103,3,b

I have done half part using tnormalize and got the output as

101,a

101,b

101,a

102,a

103,b

103,a

103,b

How to get the index count

Re: Count index values

TRF — Wed, 30 Oct 2019 13:30:00 GMT

What's the final expected result?
101,3 (as there is 3 different values for col1)
102,1 (as there only 1 value)
103,2 (as there is 2 values)

What else?

Re: Count index values

Anonymous — Wed, 30 Oct 2019 13:34:40 GMT

Hi,

Since you have already normalized data, I am not repeating that part. The output from the normalized data can be passed to a tMap to generate the sequence. Please refer the screen **bleep**s below.

Numeric.sequence(row1.id,1,1)

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Count index values

Anonymous — Wed, 30 Oct 2019 13:35:55 GMT

My expected output should be like

101,1,a

101,2,b

101,3,a

102,1,a

102,2,a

102,3,a

103,1,b

103,2,a

103,3,b

If I have 5 columns for an id I should get 5 rows with the values incremented as 1,2,3,4,5and the respective column value

Re: Count index values

TRF — Wed, 30 Oct 2019 13:37:33 GMT

Twice the same question
https://community.talend.com/t5/Design-and-Development/Transpose-column-to-row/m-p/205927/highlight/false#M112700

Re: Count index values

Anonymous — Wed, 30 Oct 2019 13:50:09 GMT

can we do it in tjavarow?

Re: Count index values

Anonymous — Wed, 30 Oct 2019 13:51:52 GMT

Well, you can call the function in tJavarow although tMap is my personal favourite.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Count index values

Anonymous — Wed, 30 Oct 2019 14:14:03 GMT

how to do it in tjava..please help. my id is in bigdecimal

Re: Count index values

Anonymous — Wed, 30 Oct 2019 15:01:20 GMT

Hi,

You can either use tConvertType component to convert the data type from one to another. If you are expert in java, you can directly use Java data type conversion functions.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved