Hi Everyone,
Good day!
I would like to seek for your expertise if it is possible for KNIME to extract table data in txt file same as the file attached.
The table could be dynamic, which means it can have more rows.
I want to get headers and row data.
Thanks in advance.
sample.txt (5.5 KB)
Hello @gft2012,
it’s possible. You can use File Reader node with some weird delimiter (“#$#”) in order to read entire data in one column. Then use Cell Splitter with proper delimiter (“|”) to get your columns. This approach works regardless of number of columns and their names.
What is then left is to filter rows you don’t need and promote proper row to column headers. Give it a try!
Br,
Ivan