Forum Discussion
Automatically group using keywords
Not sure this is even possible but here goes. I have a very large column with various text. I want to use certian keywords to group things together. For exmaple there may be the following: cis...
Hi lfk32,
If you have a fixed set of groups, you can solve your problem with a calculated column and SWITCH ( TRUE(), ... ) in it:
If your set of groups is expected to be updated frequently then you might need to keep it in a separate table, solution will be more complicated then.
Best Regards,
Alexander
This is working very well but ran into a issue. Minor and could probably work around it but maybe there is a fix.
One of the keywords in my big list is "git". I found that its also matching on "digital" since "git" is also foundin "Digital". Is there a way to specify the value must be an exact match?
Can you try putting the line with "digital" in SWITCH above the line with "git"?
Best Regards,
Alexander
- Yep worked fine.