i have row filled with values in tfileinputdelimited . Help me converting to a specified format as below

[Anonymous]

Actually , my reqt is the count can be dynamic , say if count is 5  , then there should be 5 ids in a row.

The input column can have thousands of Ids.

 (content in tfileinputdelimited.)

1

2

3

4

5

6

7

8

9

10

should be as

1,2,3,4,5

6,7,8,9,10

[Anonymous]

@fdenis what is the modulo of the line index-1 ?

[TRF · Accepted solution]

The idea of @fdenis is a good one.

Here is a new version.

rahin.zip

[Anonymous]

TRF,

Fantastic . Thanks for my urgent help. May i know fdenis proposed solution is ?

[fdenis]

modulo the integer part of the division:
6 mod 3 --> 2
8 mod 3 --> 2
10 mod 3 --> 3

so with tMap add one integer variable named var1 (center Part)
set it as Numeric.sequnce("s1",1,1)
on the output add id column type integer set value as :Var.var1 mod 5
then add your tdenormalize on the data column.