How to sort rows values ASC

Highlighted
Six Stars

How to sort rows values ASC

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


Accepted Solutions
Employee

Re: How to sort rows values ASC

Hi Steve,

 

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

image.png

 

image.png

 

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 :-)

Employee

Re: How to sort rows values ASC

Hi Steven,

 

    Please refer the screen shots below.

image.png

 

image.png

 

image.png

 

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 :-)

Employee

Re: How to sort rows values ASC

Hi Steven,

 

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

image.png

 

image.png

 

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 :-)


All Replies
Employee

Re: How to sort rows values ASC

Hi Steve,

 

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

image.png

 

image.png

 

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 :-)

Six Stars

Re: How to sort rows values ASC

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

Re: How to sort rows values ASC

Hi Steven,

 

    Please refer the screen shots below.

image.png

 

image.png

 

image.png

 

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 :-)

Six Stars

Re: How to sort rows values ASC

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

Re: How to sort rows values ASC

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
Employee

Re: How to sort rows values ASC

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 :-)

Six Stars

Re: How to sort rows values ASC

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/
Employee

Re: How to sort rows values ASC

Hi Steven,

 

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

image.png

 

image.png

 

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 :-)

Six Stars

Re: How to sort rows values ASC

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download