I would use JAVA transformation with cycle for (i=0; i<=col1; i++) Out_port=Out_port+ col2;
Thanks for answering Vlad
Is there any other way for implementing this? Using Expression Transformation.
Not built into the tool. An EXP won't help because the EXP is a passive transformation whereas for this task you need some active transformation logic.
A Normalizer can be used if (and only if) the maximum number of potential repetitions is known in advance. For example, if you know that the first column in this file can never exceed a value of e.g. 50, then you can do it using an EXP, a Normalizer, and a Filter transformation.