I am aiming to get the count of specific text from a column.
With the example attached, I have 2 columns : Data and Status. From Data column, I have 4 unique values and with different statuses from Status column.
from the output table, i would like to come up with the table with the unique Data and the count of status.
Please take note that the status may have pretext to it or in other words, i have to use regex
I.m.o spltting the Status column (using a cell splitter, string manipulation, regex node) into anytext and status is the key to the solution (create a pivot table). So more information is needed about the content ot the Status column. Is it possible to provide some sample/dummy records? That makes is easier for the communtiy to find a solution for you.
gr. Hans
Hi @ayemotep , sure, there are a few ways to do this. Here are 2 easiest ways to do it:
1). You can open import my workflow and open it, Knime should notify you that Column Expressions is missing and it will ask if you want to install it, and you can let Knime install it for you.
2). You can go to the Knime hub and get the Column Expressions from there:
You can literally drag the node from there to your workflow, and Knime will notify you that you need to install the relevant extensions, and will prompt you if it can do so. Let Knime install the extension.