topic Re: Sort Data with 2 or 3 levels in Talend Studio

Sort Data with 2 or 3 levels

Anonymous — Sat, 16 Nov 2024 05:08:35 GMT

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.

Re: Sort Data with 2 or 3 levels

ThWabi — Mon, 29 Jul 2019 14:19:43 GMT

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.

Re: Sort Data with 2 or 3 levels

Anonymous — Tue, 30 Jul 2019 10:22:27 GMT

Thanks so much.