Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
Filter data: If data contains | then don't consider those records
sgnarkhede2016
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
Find more posts tagged with
AI Studio
Filtering
Accepted answers
All comments
BalazsBaranyRM
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
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups