Find differences in two index datasets

SupportCommunity FPScript Find differences in two index datasets

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Autor
    Beiträge
  • #12532
    Bernward GreweBernward Grewe
    Teilnehmer

    I have two index datasets created with different kinds of event isolation. The second one is created by filtering the first one. How can I get the indices that are in the first and not in the second index dataset?

    #8195
    Bernward GreweBernward Grewe
    Teilnehmer

    I have two index datasets created with different kinds of event isolation. The second one is created by filtering the first one. How can I get the indices that are in the first and not in the second index dataset?

    #8865
    Bernhard KantzBernhard Kantz
    Moderator

    Using the FPScript function IndexNot() and IndexAnd(), you’ll get the indices thar are in the one but not in the other dataset. Here is an example:

    
    Dim aa, bb, cc, dd
    
    aa = {1,3,5,7, 11, 4, 34}
    bb = ValuesInInterval(aa, 0, 10, EVENT_INDEX)
    cc = ValuesInInterval(aa, 0, 5, EVENT_INDEX)
    dd = IndexNot(cc, NumberOfValues(aa))
    IndexAnd(bb, dd)
    

    The variable bb contains the indices of the values within the interval 0 to 10. The variable cc contains the indices of the values within the interval 0 to 5.
    Use the IndexNot function to get all indices of the values which are not in the interval 0 to 5. The result of the IndexAnd function is a data series with the indices which appear in both arguments. In this case the result is a data series with the indices of values within the interval ]5,10].

    support@weisang.com

Ansicht von 3 Beiträgen - 1 bis 3 (von insgesamt 3)
  • Du musst angemeldet sein, um auf dieses Thema antworten zu können.