Help need separating column

KNIME Analytics Platform
1

Hi I am cleaning up a excel file in KNIME and ran into a roadblock.

I have rows with info on two and sometimes 3 rows that I would like to combine on one row. For eg. the number and the name that follows in the Product column should be grouped together.

image
image711Ă—181 4.81 KB

2

image
image814Ă—142 4.45 KB

3

Hello @maya29 ,
Can you try using the Column Combiner node and let us know if it works?

Thanks,
Sanket

1 Like
4

it doesn’t work. For e.g. the rows need to be combine for e.g. 10066 MOTOR- Motor should all be in one row.

5

Hi @maya29 ,

Some questions:

  1. Is there always a blank row between the “groups” that should be together.

  2. How many columns are to be merged for each set of rows. In the first image there is just “Product” but in the second image there is “Product” and “Column6”

  3. Where there are multiple columns, what is the sequence of the values to be merged. e.g. The cell values of 1st column then cell values of 2nd column and so on?

  4. Is there only ever “other” data on one row in the rows that are to be merged?

Perhaps you could upload a small sample of the data?

2 Likes
6

I’ve made some assumptions that the answers to the above questions are:

  1. Yes
  2. There can be many, but they will be known at design time
  3. Values are to be merged in the sequence I described
  4. I’m guessing yes, but if there is data in more than one row to be merged, it should also be merged for the individual column

Try this:

Merge rows using groupings and unpivoting.knwf (85.6 KB)

image
image1562Ă—714 70 KB

1 Like
7

Book1.xlsx (12.1 KB)
Here is an exmple of the Date and the expected outcome. Thanks alot for the help!