Profile picture for user knircky

 

I have a question about converting XLS files into a data feed.   I have a table that looks like this  
US Actual Actual Actual
Month Jan Feb Mar
X1:  $      11  $     5.00  $      7.00
X2  $      200.46  $     7.14  $      8.68
  I now need to create something that looks like:   X1, $11, Jan, Actual X2, $200, Jan, Actual X1, $5, Feb, Actual etc   So basically I need to use column values as row values, or interpret column values as values. However what I have seen I cannot access any of the column names in any way.   How do I deal with this?
by Sebastian Stein
Posted on Fri, 10/23/2009 - 13:07

Hi Phil,

do you want to do this kind of conversion outside of or inside ARIS MashZone? I think it might be easier to do it with a small makro directly in excel.

Sebastian

0
by Phil Knirck Author
Posted on Fri, 10/23/2009 - 15:26

What I have actually done is intepret every row seperately as data feed that works but is a lot of work. So I think, you might be right about using excel for this. 

 

 

0
by Stephan Freudl
Posted on Mon, 10/26/2009 - 12:21

Hi Phil,

I must aggree: You hit a weak spot. ARIS MashZone depends on row-based data as it expects different semantics in each column. As long as there is no transpose operation I suggest to adjust the data source.

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