AS

I've found a problem with the treatment of missing values in feeds. Steps to re-create:

  1. Create a data source in a feed
  2. Use a Filter operator to filter the feed until there are no rows returned
  3. Use a Feed to Value operator to convert to a single value

A preview of the output shows the Single Value is missing/blank/null (the UI doesn't make it clear). Now when you attach that value to another operator you get inconsistent results:

  • Attaching this as a condition in a Filter operator, the value is treated as an empty string and will filter using that value
  • Attaching this as a condition to a Replace Values operator, the value is treated as missing, and the condition will default according to the option you select (met, not met)

In contrast:

  1. Create a User Input operator in the feed
  2. Do not assign a user input to it in the display

Now when you attach this value as a condition to the Filter or Replace Values operator, they work in the same way, as if the value is missing.

What this means is that you can't have a missing value generated by a feed, only by user input, and even then, only by using the display elements "no selection" or "delete selection" options.

Is there any other way to generate a missing value within a feed to get round these problems?

Andy

by Bernd Ziegler
Posted on Tue, 04/08/2014 - 10:49

Hello Andy,

sorry, but I can't reproduce the described behavior for the Single Value. I tried to create an example as yours, but  I got always a missing Single Value after my row filter ( watch attached screen).

Is it possible to you to make a screenshot of your feed? What MashZone Version do you have?

Thanks,

Bernd

 

 

 

 

File attachments
0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • CR
  • BH
  • Profile picture for user Ivan.Ivanov.softwareag.com
  • Profile picture for user mscheid
  • MS
  • PacMan

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