We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

Set the priority for the input records

Comments

1 comment

  • Avatar
    Infogix Support
    Originally posted by: stonysmith

    This should do what you want.
    It matches the Employee to BOTH priorities, and then uses Duplicate Detection to find the ones that did have more than one priority.
    It then uses an AGG to take the lowest (#1) priority for each Employee.
    node:Static_Data
    bretype:core::Static Data
    editor:sortkey=5b1575290dc53941
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    EmpNo,Dept,DeptNo
    101,Mech,100
    102,Civil,200
    103,Mech,100
    104,Comp,300
    104,Comp,400
    
    EOX
    editor:XY=110,140
    end:Static_Data
    
    node:Set_Priority
    bretype:core::Sort
    editor:Label=Set Priority
    editor:sortkey=5b15765d10f12893
    input:@40fd2c743ebf4304/=Static_Data.40fe6c55598828e5
    output:@40fd2c746a2a3b47/=
    prop:CompareOrderExpr=<<EOX
    EmpNo,DeptNo
    EOX
    editor:XY=200,140
    end:Set_Priority
    
    node:XRef
    bretype:core::X-Ref
    editor:sortkey=5b1575443e201c16
    input:@45781ca80c2802d0/=Set_Priority.40fd2c746a2a3b47
    input:@45781ca971fe502f/=Static_Data_3.40fe6c55598828e5
    output:@45781cad02e051b0/=
    output:@457826825d7c2de0/=
    output:@4578268450ad5d88/=
    prop:LeftInputKey=<<EOX
    EmpNo
    EOX
    prop:RightInputKey=<<EOX
    EmpNo
    EOX
    prop:SortLeftInput=true
    prop:SortRightInput=true
    editor:XY=310,170
    node:Sort_2
    bretype:::Sort
    editor:shadow=45782670131b71e8
    input:@40fd2c743ebf4304/=
    output:@40fd2c746a2a3b47/=
    end:Sort_2
    
    node:Bypass_3
    bretype:::Bypass
    editor:shadow=4578267017753cec
    input:@45782010749f0c96/=
    input:@457820124fef7658/=
    output:@40fd2c7436717256/=
    end:Bypass_3
    
    node:Join
    bretype:::Join
    editor:shadow=457826701862249e
    input:@40fd2c745b6d7704/=
    input:@40fd2c74504921cd/=
    output:@40fd2c7430f76546/=
    output:@457826cc03a465f4/=
    output:@457826cc510c69e0/=
    end:Join
    
    node:Bypass
    bretype:::Bypass
    editor:shadow=4578267041681261
    input:@45782010749f0c96/=
    input:@457820124fef7658/=
    output:@40fd2c7436717256/=
    end:Bypass
    
    node:Sort
    bretype:::Sort
    editor:shadow=4578267075a60d09
    input:@40fd2c743ebf4304/=
    output:@40fd2c746a2a3b47/=
    end:Sort
    
    end:XRef
    
    node:Duplicate_Detection
    bretype:core::Duplicate Detection
    editor:sortkey=5b15756f06eb3eb9
    input:@412b51602ae908b4/=XRef.457826825d7c2de0
    output:@412b51604cbd4212/=
    output:@45770db33b314718/=
    prop:ErrorIfDuplicates=false
    prop:InputExpr=<<EOX
    EmpNo
    EOX
    editor:XY=420,170
    node:Error_if_dups_found
    bretype:::Error if dups found
    editor:shadow=45770da20c26095b
    input:@40fd2c74167f1ca2/=
    output:@40fd2c7420761db6/=
    end:Error_if_dups_found
    
    node:sort
    bretype:::Sort
    editor:shadow=45770da245f22c38
    input:@40fd2c743ebf4304/=
    output:@40fd2c746a2a3b47/=
    end:sort
    
    node:Join
    bretype:::Join
    editor:shadow=45771849435f233f
    input:@40fd2c745b6d7704/=
    input:@40fd2c74504921cd/=
    output:@40fd2c7430f76546/=
    output:@457720e45ed701a9/=
    end:Join
    
    node:Agg
    bretype:::Agg
    editor:shadow=45772d9e1f7c1166
    input:@40fd2c7427456e5b/=
    output:@40fd2c744c862db0/=
    end:Agg
    
    end:Duplicate_Detection
    
    node:Static_Data_3
    bretype:core::Static Data
    editor:sortkey=5b1575347f2026f7
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    EmpNo,Name,Address,Company 
    101,AAA,sssss,Company1
    102,BBB,sssss,Company2
    103,CCC,sssss,Company3
    104,DDD,sssss,Company4
    105,EEE,sssss,Company5
    
    EOX
    editor:XY=190,230
    end:Static_Data_3
    
    node:Select_First
    bretype:core::Agg
    editor:Label=Select First
    editor:sortkey=5b15758b78ad326b
    input:@40fd2c7427456e5b/=Duplicate_Detection.45770db33b314718
    output:@40fd2c744c862db0/=
    prop:GroupBy=<<EOX
    EmpNo
    EOX
    prop:Script=<<EOX
    
    emit * 
    where firstInGroup
    
    EOX
    editor:XY=520,180
    end:Select_First
    
    node:Cat
    bretype:core::Cat
    editor:sortkey=5b1575a874657d00
    input:@40fd2c7476b11c42/=Duplicate_Detection.412b51604cbd4212
    input:5b1575b051105728/out1=Select_First.40fd2c744c862db0
    output:@40fd2c74676e03c3/=
    editor:XY=620,170
    end:Cat
    0
    Comment actions Permalink

Please sign in to leave a comment.