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
Perfect. Exactly what i was looking for and works exactly how I need.