topic Re: How to sort rows values ASC in Talend Studio

How to sort rows values ASC

stvn — Thu, 21 Feb 2019 15:27:50 GMT

Hi,

How can I sort the rows bellows in Talend?

/Default/
/Default/Usines/
/Default/Usines/Documents/
/Default/Usines/Documents/Articles/
/Default/Usines/Documents/Articles/Factures/
/Default/Usines/Documents/Articles/Factures/Depenses/
/Default/Usines/Documents/Articles/Factures/Depenses/Steeve/
/Default/Usines/Documents/Pierre/
/Default/Usines/Documents/Pierre/Pierre2/
/Default/Usines/Documents/Pierre1/Pierre2/Pierre3/
/Default/Documents/
/Default/Documents/Articles/
/Default/Document/
/Default/Document/Pierre1/
/Default/Document/Pierre1/Usine/
/Default/Document/Pierre1/Usine/Articles/
/Default/Document/Pierre1/Usine/Articles/Factures/

I tried tSortRow and tDenormalized, tExternalSortRow and nothing happend.

Thanks in advance for your help

Steve

Re: How to sort rows values ASC

Anonymous — Thu, 21 Feb 2019 15:59:12 GMT

Hi Steve,

I was able to sort it properly. Please refer below.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to sort rows values ASC

stvn — Fri, 22 Feb 2019 07:18:52 GMT

Hi,
is it possible to sort by String length?
Thanks for your Help.
Warm regards,
Steeve

Re: How to sort rows values ASC

Anonymous — Fri, 22 Feb 2019 08:19:54 GMT

Hi Steven,

Please refer the screen shots below.

Hope I answered your query 🙂

Please remember to mark the topic as resolved before going and Kudos will be a bonus 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to sort rows values ASC

stvn — Fri, 22 Feb 2019 10:31:23 GMT

Hi,
It works perfectly.
Again thanks you for your great job. As you usual you re doing a great job.
Warm regards,
Steve

Re: How to sort rows values ASC

stvn — Fri, 22 Feb 2019 10:41:01 GMT

Hi again,

Sorry to come to you, I was just wondering how I can remove the (.length) in my output?
/Default/;9
/Default/Document/;18

Thanks for your reply

Re: How to sort rows values ASC

Anonymous — Fri, 22 Feb 2019 10:50:14 GMT

Hi Steven,

Sure. Please add a tMap after tSortRow and in the output section, do not map the length column.

Very simple 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to sort rows values ASC

stvn — Fri, 22 Feb 2019 10:56:28 GMT

Re: How to sort rows values ASC

Anonymous — Fri, 22 Feb 2019 11:05:43 GMT

Hi Steven,

I was mentioning like below. I got it in right order.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to sort rows values ASC

stvn — Fri, 22 Feb 2019 11:21:08 GMT

Hey!

I Thanks you were right. My mistake was on the tSortrow where I kept the Alpha Sort. So it's more clear now. Some times I ask myself why I want to make thinks complicated. Anyway a great Thanks to you.
Warm regards,
Steve