LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  HALP PLZ How to multiply data ... See attachment

    Employee
    Posted 11-30-2018 02:02

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: a7n

    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.  RE: HALP PLZ How to multiply data ... See attachment

    Employee
    Posted 11-30-2018 07:34

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    Here's how I would do it:

    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