Hi all

I work whit MashZone, I need show in a table the values of a excel file every day, but this file one day has 8 columns and  n-rows, another day has 5 columns and n rows, another day has 12 columns and n rows and so on, the file have dynamic columns

How I can do to work with the dynamic columns in MashZone ?




File attachments
by Andy Smy
Posted on Fri, 02/07/2014 - 14:52

Assuming that you know the full set of expected column names, a data feed can be created to handle this, using crosstab.

I can't upload a picture quickly, but let me describe the steps:

  • One of the columns of data in the Excel spreadsheet must be there every day and must be a unique identifier for the row.
  • If that's missing, add a column of unique IDs every day before you upload to the server.
  • The unique ID must be in the first column of the spreadsheet for this to work.

Create a data feed with the following operators:

  1. Source MS Excel, Crosstab, Horizontal iteration from row 1, Values from row 2.
  2. Copy Feed (string together Copy Feed operators to accomodate the number of possible columns you ever expect)
  3. For each column, repeat the following:
  4. Filter Values, Horizontal Iteration = <Expected Column Name>
  5. Delete Columns Horizontal Iteration
  6. Rename Columns Values --> <Expected Column Name>

Then use Combine Feed operators on Vertical Iteration = Vertical Iteration to re-combine each column in turn.

Finally, use a Rename Columns operator to rename Vertical Iteration back to the name of the unique ID column in your source, or ignore it if you added it yourself in the first place.

So now if a column is not supplied one day, the values in that column will be blank in the output of the feed, but the column will always be there.

I can't help on a dynamic table in the display, perhaps someone else can help with that bit.



Featured achievement

You blog more than you breathe, and your articles stand out: Create 20 more articles, receive very good feedback and stimulate conversations
Recent Unlocks


Weekly | All-time
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