Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: Tim MeagherHi,
Assuming that your account number is in a field called "Account", and it is a string field, the simplest way to do this is using a Split node, and just entering the following in the "PredicateExpr" field:
If this is an integer field, you'll need to convert it to a string first using
If you need to more than just split the data and want to use a filter node, then you should have something like:
smallLength = 'Account'.strlen() <= 6
output 1 {
emit <things to emit>
where smallLength
}
output 2 {
emit <things to emit>
where not smallLength
}