Help organising my data table

KNIME Analytics Platform
1

Hi everyone,

    I'm new to KNIME and have been playing around with it for a few weeks now on and off. I'm starting to get the basics, but am blocked with a problem organising my data table.

I have inputted a data table from a .txt file and have removed some of the unwanted lines and columns, however my data is all organised in one column (column 1) with blank rows separating different groups of data points. How can I reorganise this to have one group per column rather than all of them in the same column?

 To make matters a little more complicated, there are varibale numbers of data points per group and variable numbers of groups per sheet. The name for each group is in the middle of the file path (column 0) separated by a "\" to the left and a "/" to the right. I've tried using these markers with a Regex split but I must be doing something wrong.

 

 An example table is attached as it won't display correctly here.

Thanks in advance for any help you can give me. I'm looking forward greatly to getting passed this blocking point and starting to play with my data!

Andy

2

Hi Andy,

I have created an example workflow for you that makes use of the Pivoting node. Is this what you were looking for?

Cheers,

Roland

3

Thanks very much Roland that's great. I'll have a look at what you did in more detail over the next few days and try and work out how you managed to solve this problem.

Thanks again for this help, I really appreciate it.

Andy

4