-
1. Re: Automatically pull out common words from blocks of text?
Chris McClellanFeb 9, 2015 5:53 PM (in response to michael.caloz)
Sounds very possible, check the attachment.
-
156279.twbx 12.9 KB
-
-
2. Re: Automatically pull out common words from blocks of text?
michael.caloz Feb 10, 2015 9:09 AM (in response to Chris McClellan)Excellent -- thanks very much, Chris! This is exactly what I needed for a first step.
Now, do you have any suggestions for how to deal with a lot of keywords? I see that you set up the tasting note keywords by manually creating two calculated fields for each. But, my data set contains hundreds of wines whose tasting notes contain dozens or hundreds of potential keywords.
So, it seems like either: (1) I'll need to read through all the tasting notes and manually create a calculated field for each keyword therein, or (2) I'll need a way to have Tableau automatically create a calculated field for each word that appears in all the tasting notes.
Do you have any advice?
-
3. Re: Automatically pull out common words from blocks of text?
Joe OppeltFeb 10, 2015 9:23 AM (in response to michael.caloz)
1 of 1 people found this helpfulYou want to reshape your data so that keywords are identified before tableau opens it.
Otherwise you'll need to create a million calcs, depending on how many words you want to examine. (OR, perhaps, have some secondary data source with the list of words you want to examine and do something with that.)Consider googling "keyword search tool". There are all sorts of tools out there that will serve you better. Once you have it parsed, THEN you can use tableau to viz the results.
-
4. Re: Automatically pull out common words from blocks of text?
Praveena Prabhu Feb 10, 2015 10:37 AM (in response to michael.caloz)Just an additional input, if you create a parameter as data type string Enter Text and use that in a calculated field-
if find([Notes], [Enter text]) > 0 then [Rating] end. That would make rating calculation dynamic. Attached is the workbook for reference.
Hope this helps.
-
text rating.twbx 9.5 KB
-
-
5. Re: Automatically pull out common words from blocks of text?
kettan Feb 10, 2015 10:59 AM (in response to michael.caloz)You could use method 5 in The Cross Join Collection:
SELECT * FROM [data$] d, [lookup$] l WHERE ' ' + d.[Notes] + ' ' LIKE '% ' + l.[Word] + '[ ,;.:!?]%'
See more in attached files.
Ps. You need to open files with legacy connector if data source is Excel, Text, or Access.
-
6. Re: Automatically pull out common words from blocks of text?
michael.caloz Feb 16, 2015 9:17 AM (in response to kettan)Thanks very much, Joe, Praveena, and Kettan -- a combination of all of your answers is exactly what I needed! Thanks especially to Kettan for the idea to set up wordstems and the SQL query like that.
Have a great week,
Michael
-
7. Re: Automatically pull out common words from blocks of text?
Ismael Peregrina Jan 15, 2019 9:25 AM (in response to michael.caloz)Hi Michael , did you get to finalize this tableau dashboard? I am looking to do exactly the same and it would be very useful if you could share any insight of how you finalized it.
-
8. Re: Automatically pull out common words from blocks of text?
Chris McClellanJan 15, 2019 1:59 PM (in response to Ismael Peregrina)
The last time Michael logged in was Feb 2015, so it might be a better idea to start a new thread and the current users can help you