Forum Discussion

lfk32's avatar
lfk32
Regular Visitor
3 years ago

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...
Need Help
barritown's avatar
barritown
Solution Sage
3 years ago

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

My YouTube vlog in English

My YouTube vlog in Russian

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Perfect. Exactly what i was looking for and works exactly how I need.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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?