Seven Stars

Sorting data in column

I am getting the output as 

SortC.jpg

 

But i want to data to be displayed as 

SortDjpg.jpg

 

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

Tags (1)
4 REPLIES
One Star

Re: Sorting data in column

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

Seven Stars

Re: Sorting data in column

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

One Star

Re: Sorting data in column

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

Seven Stars

Re: Sorting data in column

Please find the attached, 

DAS4.jpg