Talend community forum / tMap tranform table ?

N1866 · 2012-01-27 10:26:59

Tags: [database, development, mssql, tmap]

Hi,

I'm trying to transform data from an exisiting database using the sql ranking-function.
The sql result looks like this

id date value ranking
001 2012-01-27 85 1
001 2012-01-22 80 2
001 2012-01-15 82 3
001 2012-01-08 81 4
002 2012-01-26 20 1
002 2012-01-22 19 2
002 2012-01-15 22 3
003 2012-01-07 18 4

What I'm trying to archieve is an output looking like this

id 1 2 3 4
001 85 80 82 81
001 20 19 22 18

Unfortunately tMAP doesn't output the ranking and i have no idea how to solve my issue
since I'm quite new to TIS.

Thanks fpr your support !

Nils

mpa · 2012-01-27 11:42:18

N1866,

I think tDenormalize should give the desired output. Have a look at it in the components manual.

Edit: This will result in a column seperating the values by ";" for example. To split this one column into several columns you should also use a tExtractDelimitedFields.

Regards

Last edited by mpa (2012-01-27 11:45:31)

N1866 · 2012-01-27 12:38:30

Hi mpa,

thanks for helping me out. These components just work with string, right ?

mpa · 2012-01-27 15:54:37

Yea I would assume it only works with string. Because your concatenating the values before you split them into multiple rows.

Announcement

Unanswered posts

#1 2012-01-27 10:26:59

tMap tranform table ?

#2 2012-01-27 11:42:18

Re: tMap tranform table ?

#3 2012-01-27 12:38:30

Re: tMap tranform table ?

#4 2012-01-27 15:54:37

Re: tMap tranform table ?

Board footer