Accepted Solutions
Community Manager
Hi @Batista,
It sounds like perhaps Indicator Columns of those terms would be useful for you. I would use Analyze > Text Explorer. Place your text column in as Text Column, and click OK. You'll see a list of the most common terms and phrases in your rows of text. You can sort by Term alphabetically by clicking the header, or find your terms based on their frequency of occurrence (the default sort order). Find the terms you mentioned, right-click the terms and then select Save Indicators.
This will save new columns with a 1 if that term if present in the given row of text. 
Community Manager
Hi @Batista,
It sounds like perhaps Indicator Columns of those terms would be useful for you. I would use Analyze > Text Explorer. Place your text column in as Text Column, and click OK. You'll see a list of the most common terms and phrases in your rows of text. You can sort by Term alphabetically by clicking the header, or find your terms based on their frequency of occurrence (the default sort order). Find the terms you mentioned, right-click the terms and then select Save Indicators.
This will save new columns with a 1 if that term if present in the given row of text.
Community Manager
Hi @Batista,
I'm not sure if I completely understand now what you're trying to do here. But, I think what you have are several indicator columns now and you would like a single column that shows if any one of them was present. In those situations, I create a Formula Column taking the Max() of the indicator columns. You can do this with New Formula Column right in the data table by selecting the columns, then Right Click a column header > New Formula Column > Combine > Maximum. You will then have a single indicator of the presence of any of those terms.
If this isn't what you're after, could you explain a little bit more about your goal here? It would also be helpful if you could provide a piece of your data, or at least a screenshot so we can better see how your data are currently organized.
