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


in Help
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
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:
0
Answers
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