Talend community forum / sort list of values

sg9 · 2011-04-06 14:31:02

Tags: [context, CSV file, database, deployment, development, java]

hi,
i have a table with following fields:

f1, f2, detail1,detail2,detail3,detail4,detail6

i want to output into another table where details are concatenated with "_" in between and in alphabetic order:

fi, f2, details
where details = filed1_field2_field3_...field6 but in alphabetic order.

jdufay · 2011-04-06 15:00:54

What do you mean with "in alphbetic order" for details = filed1_field2_field3_...field6?

Last edited by jdufay (2011-04-06 15:56:20)

alevy · 2011-04-07 05:02:46

You would need to normalise the details, sort them and then denormalise again.

Announcement

Unanswered posts

#1 2011-04-06 14:31:02

sort list of values

#2 2011-04-06 15:00:54

Re: sort list of values

#3 2011-04-07 05:02:46

Re: sort list of values

Board footer