Hi Guys ,
I need some help as i am new KNIME.
I have a txt file similar to below.
I need to extract this data in below format.
Is it possible to do ?
This is sample data . my data is very big thats why i want to use KNIME.
Summary of Data.txt (813 Bytes)
Hello @praffulgoyal,
and welcome to KNIME Community!
You can try CSV Reader node and tab (\t) as a column delimiter with option Support short data rows checked.
Br,
Ivan
Is this the actual format of your data? Its a mess and will require extensive manipulation in order to process it.
@praffulgoyal I have taken the liberty to expand the solution by @rfeigel to have a dynamic detection of the start of the second table:
there are multiple ways to solve this, depending a bit on how alike the sample is to the full data set.
if the 2 example blocks are all, then I would just configure 2 csv readers with hardcoded amount of rows skipped etc.
if this isnt the case, but the structure repeats exactly as is, I would recommend to do it in 2 steps:
first step splitting the file and creating new files for each “block”. and then reading them in
@mlauber71 Very nice improvement! Kudos to you.
