Hi,

I want to make  transformation for all row how have the same Id in context of Extract-Transform-Load directly in Buffer how have a defined shema.
I try to use tjavaFlex with buffer to do that but I have a problem with using Buffer variable in tjavaFlex,I don't know if TOS give possibilities to use component variable (Metadata attribuite) in java component.
I think that is the same way of  tSortrow (virtual component) but using agregation of rows how have the same Id :


        String thisS<%=colname %> = String.valueOf(this.<%=colname %>);
        String otherS<%=colname %> = String.valueOf(other.<%=colname %>);
        if(!thisS<%=colname %>.equals(otherS<%=colname %>)){
<%
                            if(asc){
                            %>
            return thisS<%=colname %>.compareTo(otherS<%=colname %>);
                            <%
                            }else{
                            %>
            return otherS<%=colname %>.compareTo(thisS<%=colname %>);
                            <%
                            }



Thanks

Hello together,

months ago I wrote a article about mergint n rows to one. May be this could help you. If not. Can you please give some more details about your input and output.

talendforge wiki: use case 12

Bye
Volker

You are welcome.

And if you would like to share your solution I think there is no problem to add a new use case (or add some more information to my one).

Bye
Volker