Filter data: If data contains | then don't consider those records

sgnarkhede2016
sgnarkhede2016 New Altair Community Member
edited November 5 in Community Q&A
Hello,

If multiple attribute contains attribute value like A|B or 123|987
how to handles dynamically w.r.t all attributes

Thanks,
Sachin N
Tagged:

Answers

  • BalazsBarany
    BalazsBarany New Altair Community Member
    Hi,

    you could use Loop Attributes and inside that Generate Attributes with something like:
    match = match || contains(%{attr}, "|")

    Initialize match with false, and filter records that have match = true after. The expression changes to true if one of the attribute values contains the character |.

    If it were a different character, you could use Generate Aggregation with the concatenate function - but unfortunately it uses exactly | for separating the resulting string.

    Regards,

    Balázs

Categories