The Spotfire Community is moving to TIBCOmmunity and this forum location has closed. During the transition, you can still search the old forums but posting has been disabled. We encourage you to pick up the discussion at the new Spotfire community on TIBCOmmunity.
S+ Database functionality - TIBCO Spotfire Community

S+ Database functionality

Last post Wed, Aug 8 2012 10:20 AM by Dan White. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • Thu, Apr 19 2012 11:48 PM

    S+ Database functionality

    Using MS Access I can take two lists of data List A and List B and Find a new list C that is all the records in List A and exclude those that are also found in list B.

     I.e.

    List A = {apple, banana, carrot, pear, pineapple, tomato}

    List B = {pear, pineapple}

    Therefore List C = {apple, banana, carrot, tomato}  

     Can S+ do the same? 

  • Sun, Apr 29 2012 5:14 AM In reply to

    Re: S+ Database functionality

    Spotfire can do it using the Lists functionality.

     

    Christof

     

    -----------------------------------
    Dr. Christof Gaenzler
    Sr Solutions Consultant
    TIBCO Spotfire
  • Tue, Jul 3 2012 3:32 PM In reply to

    Re: S+ Database functionality

    Chirstof -

    Can you please give more detail on this.. How to implement in spotfire using lists.

    Thanks 

     

  • Wed, Aug 8 2012 10:20 AM In reply to

    Re: S+ Database functionality

    Yes, S+ can do the same:

    list.a <- c("apple", "banana", "carrot", "pear", "pineapple", "tomato")

    list.b <- c("pear", "pineapple")

    list.c <- setdiff(list.a,list.b)

     Similarly, the union command returns the unique values in both lists, and the intersect command returns only the values in common between two lists.

Page 1 of 1 (4 items)
┬ęCopyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center