Sort Data with 2 or 3 levels

[Anonymous]

Hello, 

Can I sort data with 3 levels for example

PostalCode   Product    Quantity    Date

1000              Product2    100         22/7/2019

1000              Product1    100         26/7/2019

1004              Product2    100         21/7/2019

1000              Product1    100         23/7/2019

1003              Product2    102         24/7/2019

We will sort it with postal code first then with product after that with quantity and last with date

PostalCode   Product    Quantity    Date

1000              Product1    100         23/7/2019

1000              Product1    100         26/7/2019

1000              Product2    100         22/7/2019

1003              Product2    102         24/7/2019

1004              Product2    100         21/7/2019

Is that possible in Talend? 

Thanks alot for your help.

[ThWabi · Accepted solution]

Hello RamiSaadani,

yes that it possible! Check out the tSortRow component. Depending on the amout of data you need to sort, you might want to take a look at the "Sort on disk" option under "Advanced settings".

Best regards.

[Anonymous]

Thanks so much.