Currently I have user image reader to read the image and extract the data. Now, how can i split and organize the data properly? For example, a new column for Driver Name, new column for status and so on.
The final output should same as this table:
You’re more likely to get help if you share your workflow.
Currently, I am trying out in many way (so the workflow might be very messy). But I still can’t figure it out.
Hi @Is_celine
I think what @rfeigel means, is to export and then upload your workflow including the data or at least a sample-dataset (without confidential data).
gr. Hans
1 Like
unstructured data.knwf (318.4 KB)
You didn’t include the data with your workflow. Create a folder named “data” inside your workflow folder. Store your data files in the data folder. This makes them portable with your workflow rather than having them stored on your local machine. Then point your reader nodes to those file(s).
Is this a task from a course you attend? There’s exact the same question in this thread:
Extract word ( string splitter (regex) node) - KNIME Analytics Platform - KNIME Community Forum
1 Like
yes, it is. Currently I am thinking to use string manipulation node to extract the column header like driver name, status… But it still can’t work
Hi @Is_celine
Use cell splitter with \n splitter char and list output and ungroup de list
You can then follow @alpayzeybek solution.
Best Regards
1 Like