Forum Discussion
How do I Count words in multiple columns
Hi, I want to know how to count how many times appear a word in each column: Example: there are 4 columns with replacements of a device, I want to count hoy many times appear each word on ...
Hi,
In the Query Editor, select all columns other than the 4 columns, right click and select "Unpivot Other Columns". Drag the Values column to a Table/matrix visual and write this measure
Measure = countorws(Data)
Hope this helps.