Icon

L3Harris_​Q1_​Q2_​Text_​Mining

KNIME master class - Assignment 1. Text mining of the L3Harris Q1 and Q2 2026 reports: read and clean the PDFs, tag positive and negative words, clean the words, count them and show a tag cloud. No input files are set: configure the Tika Parser, Table Writer/Reader and CSV Reader with your own files.

KNIME master class - Assignment 1. Text mining of the L3Harris Q1 and Q2 2026 reports: read and clean the PDFs, tag positive and negative words, clean the words, count them and show a tag cloud. No input files are set: configure the Tika Parser, Table Writer/Reader and CSV Reader with your own files.

STAGE 1 - Read and Clean PDFsTurn the two PDFs into clean, labeled text. You do this once.
STAGE 2 - Make Documents and TagPuts the text in KNIME's format and marks the positive and negative words.
STAGE 3 - Clean the WordsRemoves symbols, numbers, capitals and filler words so only real words get counted.
STAGE 4 - Count the WordsCounts how often each word appears and shows the most used ones in a tag cloud.

INSTRUCTIONS

BEFORE YOU RUN IT (no files are set yet)
1. Tika Parser: select the folder with the Q1 and Q2 PDFs.
2. String Manipulation: create the Quarter column from the file name (the names must contain Q1 / Q2).
3. String Replacer: add the pattern for the text you want to delete.
4. Table Writer: choose where to save the .table file. Table Reader: open that same file.
5. Strings to Document: Full text = the Tika content column. Keep the Quarter column.
6. CSV Reader: select your word list CSV (one column of positive words, one of negative words).
7. Dictionary Tagger (Multi Column): add both columns, tag type SENTIMENT, values POSITIVE / NEGATIVE, uncheck Case sensitive.
8. Bag Of Words Creator: keep the Quarter column. 9. TF: uncheck Relative frequency.
10. Tag Cloud: Term column = Term, value column = TF. Then click Execute All.

Reads the Q1 and Q2 PDFs(select your folder)
Tika Parser
Adds the Quarter column(Q1 / Q2 from file name)
String Manipulation
Deletes unwantedbackground text
String Replacer
Saves the cleaned text(.table file)
Table Writer
Opens the saved.table file
Table Reader
Converts textto documents
Strings to Document
Positive and negativeword lists
CSV Reader
Removes punctuation
Punctuation Erasure
Tags positive andnegative words
Dictionary Tagger (Multi Column)
Removes commonfiller words
Stop Word Filter
Shows the taggedreports
Document Viewer
Splits documentsinto words
Bag Of Words Creator
Removes number-onlywords
Number Filter
Makes all wordslowercase
Case Converter
Counts each word(uncheck Relative frequency)
TF
Shows the wordsby size
Tag Cloud

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Alejandro Gomez
Created at: 2026-09-27
On NodePit since: 2026-09-28
Last update: 2026-10-22
Created with KNIME version: v5.12.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!