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.  Filter specific data from a column

    Employee
    Posted 07-26-2016 06:20

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

    Originally posted by: Jagdev

    Hi Experts,

    I know this is possible to pull specific data with the help of split node. Like in a column I want to filter related values ex.

    node:Split
bretype:core::Split
editor:sortkey=579638d1106138ad
input:@40fd2c74167f1ca2/=Trim_Fields_2.440474fa418f3480
output:@40fd2c7420761db6/=
output:@456df11556bd6bcf/=
prop:PredicateExpr=<<EOX

      'Unit' == u"ABC Re Spec"
  or
      'Unit' == u"ABC Re Neee"
      or
      'Unit' == u"ABC Re NA"
EOX
editor:XY=340,110
end:Split
    Is it possible to pull related data from a column with a single line of code ex - 'Unit' == u"ABC Re *"

    Regards,
    Jahdev


  • 2.  RE: Filter specific data from a column

    Employee
    Posted 07-26-2016 08:20

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

    Originally posted by: stonysmith

    The simplest thing to do is:

    where Unit.left(6)==u"ABC Re "


  • 3.  RE: Filter specific data from a column

    Employee
    Posted 07-26-2016 09:49

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

    Originally posted by: Jagdev

    Oh! nice approach.

    Thanks
    Jagdev