I am trying to make an expression, thus it would divide data into smaller parts.
So far this expression works if the column has two values e.g. incoming and outgoing
What should I adjust for this expression ,thus it would work if the column name has three or more values?
Maybe subfield() is more suitable for splitting your data into several fields or into several rows for one field.
pick(WildMatch(value.name, '*incom*', '*outgo*', '*cancel*'),'incoming', 'outgoing', 'cancelled')