Results 1 to 2 of 2

Thread: HALP PLZ How to multiply data ... See attachment

  1. #1

    Default HALP PLZ How to multiply data ... See attachment

    Hi All

    Basically what I am trying to accomplish is multiply the data.

    I have attached what the raw data looks like in the tab RAW DATA

    and what i am trying to accomplish or how the final data set will look like in the Tab Output.

    Can any one please advise me what is the best way to get this done please......

    Link to actual data Halp Please.txt

    Raw Data
    RawData.JPG

    Output
    Output.JPG

  2. #2
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    799

    Default

    Here's how I would do it:

    Code:
    node:Join_2
    bretype:core::Join
    editor:sortkey=5c0149a677425603_2
    input:@40fd2c745b6d7704/=Join.40fd2c7430f76546
    input:@40fd2c74504921cd/=Filter.5c01491d2fa44028
    output:@40fd2c7430f76546/=
    prop:JoinType=i
    prop:LeftInputKey=<<EOX
    1
    EOX
    prop:RightInputKey=<<EOX
    1
    EOX
    prop:Script=<<EOX
    emit *
    EOX
    editor:XY=570,90
    end:Join_2
    
    node:Join_3
    bretype:core::Join
    editor:sortkey=5c0149a677425603_3
    input:@40fd2c745b6d7704/=Join_2.40fd2c7430f76546
    input:@40fd2c74504921cd/=Filter.5c01491f0f61515a
    output:@40fd2c7430f76546/=
    prop:JoinType=i
    prop:LeftInputKey=<<EOX
    1
    EOX
    prop:RightInputKey=<<EOX
    1
    EOX
    prop:Script=<<EOX
    emit *
    EOX
    editor:XY=650,100
    end:Join_3
    
    node:Join
    bretype:core::Join
    editor:sortkey=5c0149a677425603
    input:@40fd2c745b6d7704/=Filter.40fd2c7420761db6
    input:@40fd2c74504921cd/=Filter.5c01491d43ef7bd2
    output:@40fd2c7430f76546/=
    prop:JoinType=i
    prop:LeftInputKey=<<EOX
    1
    EOX
    prop:RightInputKey=<<EOX
    1
    EOX
    prop:Script=<<EOX
    emit *
    EOX
    editor:XY=490,80
    end:Join
    
    node:Filter
    bretype:core::Filter
    editor:sortkey=5c01490a0585230a
    input:@40fd2c74167f1ca2/=Static_Data.40fe6c55598828e5
    output:@40fd2c7420761db6/=
    output:5c01491d43ef7bd2/out2=
    output:5c01491d2fa44028/out3=
    output:5c01491f0f61515a/out4=
    prop:Script=<<EOX
    
    
    output 1{emit Term where Term.isNotNull()}
    output 2{emit Type where Type.isNotNull()}
    output 3{emit Size where Size.isNotNull()}
    output 4{emit Vendor where Vendor.isNotNull()}
    EOX
    editor:XY=390,90
    end:Filter
    
    node:Static_Data
    bretype:core::Static Data
    editor:sortkey=5c01487f30974361
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    Term,Type,Size,Vendor
    60,4 PT,Medium,Justice League
    12,8 PT,Large,Crazy Guy
    36,24 PT,Maxi,NULL
    48,16 PT,NULL,NULL
    24,NULL,NULL,NULL
    EOX
    editor:XY=300,90
    end:Static_Data

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •