topic Re: Sorting data in column in Talend Studio

Sorting data in column

Anonymous — Thu, 28 Jun 2018 07:39:46 GMT

I am getting the output as

But i want to data to be displayed as

Its basically the ORDER BY - ProviderID, but i am not getting the desired result. Below is the graph flow.

InputDB-->tMAp-->tAggregaterow-->tSortRow-->tMap-->Output DB

Issue example :- if you see the first images row 1 and 11, its for same ProviderID, i am expecting the data of row 11 to be followed by row 1 but its not happening, please suggest

Re: Sorting data in column

Anonymous — Thu, 28 Jun 2018 08:09:30 GMT

Hey,

are you ordering it by providerid alone or you also took measureid into the ordering process as your second picture seem to be ordered by it as well.

Kind regards,

Patrick Gornig

mayato GmbH

Re: Sorting data in column

Anonymous — Thu, 28 Jun 2018 08:24:16 GMT

in tSortRow i gave only ProviderID to display in ASC order. No other field

Re: Sorting data in column

Anonymous — Thu, 28 Jun 2018 08:45:35 GMT

Is it possible to upload a screenshot of the schema details from the input- and sort-component?

Re: Sorting data in column

Anonymous — Thu, 28 Jun 2018 11:37:29 GMT

Please find the attached,