excel columns
I am trying to setup a excel spreadsheet that will only look in one column but go thru all the rows and find all the occurrences.
right now I have to use extract document and specify each row, is their something that will do all the rows?
right now I have to use extract document and specify each row, is their something that will do all the rows?
Find more posts tagged with
Sort by:
1 - 6 of
61
I want to capture all the words in the one column and count the occurrences of each word for every row in that one column
a cell may have several sentences in it. a filter is to specific to what word you put in.
a cell may have several sentences in it. a filter is to specific to what word you put in.
Altair EmployeeHi,
read it with read excel, make the attribute text and use process documents with tokenize and term occurrences should do the trick.
~Martin
read it with read excel, make the attribute text and use process documents with tokenize and term occurrences should do the trick.
~Martin
that worked thanks now is there a way to sort by highest number descending, I tried sort but it looks to be sorting on the word and not by how many.
Altair EmployeeYou can specifiy which attribute should be used for sorting in sort.
Have you used Wordlist to Data on the wordlist? That should be exactly the format you wanted.
~Martin
Have you used Wordlist to Data on the wordlist? That should be exactly the format you wanted.
~Martin
I'm using read excel > processing doc from data if I put sort on after this it sorts the first word in the column,
I want descending order of the occurrences.so that it will be that the largest count of a word is displayed.
this is how i fixed it, there must be easier way but this is what i did.
added word list to data > write to csv > read to csv > sort (sort on the occurancts, desending)
I want descending order of the occurrences.so that it will be that the largest count of a word is displayed.
this is how i fixed it, there must be easier way but this is what i did.
added word list to data > write to csv > read to csv > sort (sort on the occurancts, desending)
Why can't you use Read Excel and use Filter Examples on it? Could you maybe post example data?
~Martin