INSTRUCTIONS

• Tika Parser: Select the C:\L3Harris_Reports folder, include only PDF files, and Ctrl+click the 2 metadata fields that show where the file is and what it says.

• String Manipulation: Create a new column called Quarter using regexReplace($Filepath$, ".*(Q[12]).*", "$1").

• String Replacer: In the text column, use the regular expression (?s)Forward-Looking Statements.* with an empty replacement on all occurrences to remove the disclaimer.

• Table Writer: Click the folder icon, go to C:\ → L3Harris_Reports, type L3Harris_Reports.table in the Name box, set If exists to Overwrite, and execute.

• Table Reader: Click the folder icon, go to C:\ → L3Harris_Reports, select L3Harris_Reports.table, and execute.

• Strings to Document: Use the file path as the title, the text as the full text, the quarter as the category, L3Harris Investor Relations as the source, and L3Harris Technologies as the author.

• CSV Reader: Open C:\L3Harris_Reports\word_lists.csv with the first row used as column names.

• Dictionary Tagger (Multi Column): Add both word list columns, tag each one as SENTIMENT with its matching value, and turn off case sensitivity.

• Document Viewer: Open the view, double-click a report, and find the tagged words.

• Punctuation Erasure: Run it with the default settings.

• Number Filter: Run it with the default settings.

• Case Converter: Make every word the same case so "Revenue" and "revenue" count as one word.

• Stop Word Filter: Remove filler words using the built-in English list.

• Bag Of Words Creator: Pick the cleaned document column, keep only Quarter and that column, and leave the term column as Term.

• TF: Use the cleaned document column and Term, and change the setting so the counts show as whole numbers.

• Tag Cloud: Use Term for the words and the TF count for the size, hide the tags, and pick the layout that ranks words from most to least used.

Session1 -Introduction to Text Processing

Assignment 1 - From PDF to insights: L3Harris Earning Reports

Description: In the first assignment, you will learn the basic steps of text processing in KNIME you will turn four L3Harris Reports from Q1 and Q2 2026 into clean text, marks the positive and negative words, count how often each word appears, and show the most used in a tag cloud.