FlexPro
HistoryBase
Engineering
Training
Downloads
FlexPro Support
Knowledge
Community
About us
References
Jobs
General Contact
List Of Retailers
FlexPro Support
EN
DE
FR
Placeholder
Products and Solutions
Support and Downloads
Company
Magazine
Contact Us
Language
MyWeisang

Account settings

Topic

Find differences in two index datasets

Home page Community FPScript Find differences in two index datasets

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #33396
    Bernward Grewe
    Participant

    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?

    #33394
    Bernward Grewe
    Participant

    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?

    #33395
    Bernhard Kantz
    Participant

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

    [code]
    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)
    [/code]

    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 [b]IndexNot[/b] function to get all indices of the values which are not in the interval 0 to 5. The result of the [b]IndexAnd[/b] 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

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.