topic Re: Increment value of column in Talend Studio

Increment value of column

Ferdinand_CUNY — Sat, 16 Nov 2024 00:51:36 GMT

Hello all,

I have a source with this structure

Date1 | ID | val1 | Val 2| Val 3

12/01 | 1 | 3 | 5 | 4

12/01 | 2 | 4 | 5 | 7

12/01 | 3 | 5 | 5 | 9

I would like obtain this structure below

Value is number of the column nuber of above

Date1 | Val1 | Val2 | Val3 | Val4 | Val5| Val6 | Val7 | Val8 | Val9

12/01 | 0 |0 | 1 | 2 |4 |0 |1 | 0 | 1

How I can implement this?

Prakhar1 — Thu, 07 Jan 2021 12:00:01 GMT

Could you also explain the logic you are trying to implement ?

Ferdinand_CUNY — Fri, 08 Jan 2021 12:48:53 GMT

It's to knwo the value the most popular