Profile picture for user carlkennedy

I have a database data feed that is extracting these values when I execute the data feed in Composer:

 

My MashApp does not display it in this sequence.  It does this:

Here is the MashApp in Composer with Sorting set to None:

We are running MashZone 2.0.0.2.116.  Would anyone have suggestions on how to correct this?

 

Best regards,

Carl

by Stephan Freudl
Posted on Fri, 05/27/2011 - 09:49

Hi Carl,

I am afraid, there is currently no way to do so in MashZone as it sorts lexicographically. To avoid sorting {1,10,11,...,2,3,...} instead of {1,2,3,...,10,11,...} you may insert trailing zeros into your age column.

Your data base might support a statement to do so. Alternatively you could do it in MashZone as your ages have a two digit maximum.

  1. Make age a numerical column (to filter for values lower than 10)
  2. Insert a helper column of type text.
  3. Set the value of the helper column to "0" in each row where age is lower than 10 - the replace value operator enables you to do so
  4. Convert age's data type back to text
  5. Concatenate the text of your helper column with the values of the age column
  6. Delete the helper
  7. Done, you'll have rows like {01,02,...,10,11,...}

Regards

Stephan

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock