How to sort rows values ASC

[stvn]

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

[Anonymous · Accepted solution]

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 🙂

[stvn]

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

[Anonymous]

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 🙂

[stvn]

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

[stvn]

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

[Anonymous]

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 🙂

[stvn]

Hi,
I did it and it gave me back the following result.
/Default/ |
|/Default/Document/ |
|/Default/Document/Steeve1/ |
|/Default/Document/Steeve1/Usine/ |
|/Default/Document/Steeve1/Usine/Articles/ |
|/Default/Document/Steeve1/Usine/Articles/Factures/ |
|/Default/Documents/ |
|/Default/Documents/Articles/ |
|/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/Steeve1/ |
|/Default/Usines/Documents/Steeve1/Steeve2/ |
|/Default/Usines/Documents/Steeve1/Steeve2/Steeve3/

[Anonymous]

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 🙂

[stvn]

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