FlexPro Forum – Discuss Your Topic!

divide dataset to multiple datasets

Home > Community > FPScript > divide dataset to multiple datasets

  • This topic has 2 replies, 2 voices, and was last updated 15 years ago by Anonymous.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #12470
    Anonymous
    Guest

    There’s a dataset which has e.g. 20000 points of data.
    I’d like to divide this dataset to 20 datasets.

    The first divided dataset has;

    First data point of original dataset,
    Second data point of original dataset,…
    1000th data point of original dataset

    The second divided dataset has;

    1001st data point of original dataset,
    1002nd data point of original dataset,…
    2000th data point of original dataset

    I know I could make every divided dataset by using index operator, but it could be complicated if I divide the original dataset into a lot of numbers of datasets.

    Please let me know if you know any way to do it with few formulas.

    #8143
    Anonymous
    Guest

    There’s a dataset which has e.g. 20000 points of data.
    I’d like to divide this dataset to 20 datasets.

    The first divided dataset has;

    First data point of original dataset,
    Second data point of original dataset,…
    1000th data point of original dataset

    The second divided dataset has;

    1001st data point of original dataset,
    1002nd data point of original dataset,…
    2000th data point of original dataset

    I know I could make every divided dataset by using index operator, but it could be complicated if I divide the original dataset into a lot of numbers of datasets.

    Please let me know if you know any way to do it with few formulas.

    #8764
    Bernhard KantzBernhard Kantz
    Participant

    1) You could use VBA to create the FPScript formulas (which use the index operator).
    2) You could use the Reshape-function to convert a signal into a signal series.
    Example:

    Formula SignalSeries

    
    Dim y = Reshape(Signal.Y, {20, NumberOfRows(Signal.Y)/ 20})
    Dim x = Reshape(Signal.X, {20, NumberOfRows(Signal.X)/ 20})
    Signal(y,x)
    

    Now you can create a formula for each signal:

    
    SignalSeries[0]
    ...
    

    support@weisang.com

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