Forum Discussion

gomezc73's avatar
gomezc73
Icon for Helper V rankHelper V
2 years ago
Solved

How Concatenate Text by Category

Hi Experts,   I have the following issue.   I have in a table the explanations of variations by accounts.   Something like these:   Lead Account Sep 23 Sep22 VARIATION Explanation ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    gomezc73 I posted the formula in the original reply. All you should have to do is replace 'Table' with your actual table name assuming that your columns names are what you posted.

     

gomezc73's avatar
gomezc73
Icon for Helper V rankHelper V
2 years ago

Hi, it is only a number 1, 2, 3, 4  or a,b,c,d..  it is only to identify that it is a separate explanatations.

 

By example, the first explanation must be '1', the second explanations must have a '2' etc..

 

thank you

CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
2 years ago

Oh, gotcha. Greg_Deckler 's solution is great. For future iterations, if the explanations are not free text, but selected from a list of standard available options, counting their frequency and ranking them might provide some useful insights. Just a thought.