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.  Exclude a value from a list

    Employee
    Posted 03-08-2018 03:01

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

    Originally posted by: dsrebelo

    Hi,

    I've a need and i don�t know how i resolve it. Any one can help me?

    The problem is:

    1. I have one list of values
    Collum_name
    A
    B
    A
    B
    B
    A
    A
    B


    2. I need to eliminate all the registers that are equal to last one. in example i need to eliminate the red ones
    Collum_name
    A
    B
    A
    B
    B
    A
    A
    B




    Any one can help me?

    Thanks,
    David


  • 2.  RE: Exclude a value from a list

    Employee
    Posted 03-12-2018 09:46

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

    Originally posted by: awilliams1024

    Please see the attached example

    Exclude_Repeated_Values.brg


  • 3.  RE: Exclude a value from a list

    Employee
    Posted 03-16-2018 02:55

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

    Originally posted by: dsrebelo

    Thanks for your help, but i couldn't open the file. I've the verion 6 of LAE ...
    could you pass the code by text? and the type of node i need to use?

    thanks a lot
    David


  • 4.  RE: Exclude a value from a list

    Employee
    Posted 03-16-2018 03:58

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

    Originally posted by: awilliams1024

    Here is the contents of the data flow

    node:Static_Data
bretype:core::Static Data
editor:sortkey=5aa6ad117f00206e
output:@40fe6c55598828e5/=
prop:StaticData=<<EOX
RecId,Data
1,A
2,B
3,A
4,B
5,B
6,A
7,A
8,B
EOX
editor:XY=310,130
end:Static_Data

node:Filter
bretype:core::Filter
editor:sortkey=5aa6ad5024c40697
input:@40fd2c74167f1ca2/=Static_Data.40fe6c55598828e5
output:@40fd2c7420761db6/=
prop:Script=<<EOX
if firstExec then {
	Previous_Value = "Not__Defined"
}


emit * where Data != Previous_Value

Previous_Value = Data
EOX
editor:XY=460,130
end:Filter