Multiple Columns data of same Employee merge in to one column

KNIME Analytics Platform
1

Hello Champs,

Hope you all doing good.

Need your kind assistance on the below problem statements,

Ex: i have the data in the below column format, Column1 is my unique identifier .

|Column1|:|X |Column2|:|Y |Column3|:|Z |Column4|:|A |Column5|:|B |Column6|:|C

So we have multiple employees row data in a similar way , i want to merge or combine all columns in to one column with multiple rows of same employees , i mean for employee X should have columns data in one single column with multiple line, Result should as per the below
Column1- Employee Name Column2
X Y
X Z
X A
X B
X C

Need all employees data in a same pattern. Need your kind support. Earlies response is highly appreciated.

Regards
Madhusudhan J

1 Like
2

Hey there,

that sounds like a job for unpivot node:

image
image1148Ă—576 21.5 KB

Here’s the workflow:

soundslikeunpivot.knwf (73.1 KB)

1 Like
3

wow is it really work sir, thank you so much , also can you help me with below one as well , i have two columns ,first column name is Columnnames and another one is ColumnValues , i am trying the below logic but finding error everytime, i have replace or append 2nd column called
Columnvalue

|ColumnNames| Columnvalues|
|—|—|—|
|I would like to have total balance paid to my pension = Yes Then replace /324
|I would like to have a specific amount paid to my account = Yes Then replace/630
|I would like to have a specific amount paid to my pension = Yes Then replace/324
|I would like to have my Employee’s Cholice paid on a monthly basis== Yes Then replace97|
|I would like to have my Employee’s Choice paid to pension on a monthly basis = = Yes Then replace/3AM

4

You are welcome.

I think your next problem is also solvable.

In order not to mix up topics can I ask you to:

  • solve this topic by clicking the checkmark under the solution
  • open a new topic for your new problem
  • I strongly recommend that instead of pasting the format of your data in the post that you prepare a representative data set (anonymised…) of your input data and also the desired output you want to achieve e.g. in Excel and upload it

From reading your request as I mentioned it does not seem difficult to solve, but I know from myself that people can be hesitant to help if typing in example data is required for them

1 Like