# ETL: Combine Values of 2 Rows

**URL:** <https://forum.knime.com/t/etl-combine-values-of-2-rows/20280>\
**Category:** KNIME Analytics Platform\
**Created:** [January 3, 2020, 3:52pm UTC](https://forum.knime.com/t/etl-combine-values-of-2-rows/20280 "2020-01-03T15:52:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sven-abx](https://forum-cdn.knime.com/user_avatar/forum.knime.com/sven-abx/32/16028_2.png) [@sven-abx](https://forum.knime.com/u/sven-abx)\
**Post date:** [January 3, 2020, 3:52pm UTC](https://forum.knime.com/t/etl-combine-values-of-2-rows/20280/1 "2020-01-03T15:52:13Z")

</div>

Hi there,

I want to combine the Values of Row0 and Row1 and then manipulate the String.  
**Example:**  
Row0 2004  
Row1 stat inv qty  
**Result:**  
Row3 qty 2004

Row0 and Row1 can be deleted afterwards.

I was able to build a process that transform the following:

 ![combine_1](https://forum-cdn.knime.com/uploads/default/original/2X/5/55c4371e41cb714ba812ead7745f10794541acdf.png)

to  
 ![combine](https://forum-cdn.knime.com/uploads/default/original/2X/7/73198d9ec939c94eafdbeedebf541d5dac04f428.png)

thru this workflow

 ![combine_2](https://forum-cdn.knime.com/uploads/default/original/2X/0/048d7a66dac1ef054d3bf87d64dd4b372517bade.png)

It looks like the workflow is a bit complicated and I would appreciate any help. Thanks

---

<div class="post-metadata">

**Author:** ![AlexanderFillbrunn](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alexanderfillbrunn/32/357_2.png) [@AlexanderFillbrunn](https://forum.knime.com/u/AlexanderFillbrunn)\
**Post date:** [January 4, 2020, 12:02pm UTC](https://forum.knime.com/t/etl-combine-values-of-2-rows/20280/2 "2020-01-04T12:02:47Z")

</div>

Hi,  
it looks like your data also makes sense if you use the values of Col0 as columns and transpose the table. Could you use the [RowID](https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.rowkey2.RowKeyNodeFactory2) node to make column Col0 into a RowID, then [Transpose](https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.transpose.TransposeTableNodeFactory) the table so they become columns and then use a [String Manipulation](https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.stringmanipulation.StringManipulationNodeFactory) node to generate your desired result?  
Kind regards  
Alexander

---

<div class="post-metadata">

**Author:** ![sven-abx](https://forum-cdn.knime.com/user_avatar/forum.knime.com/sven-abx/32/16028_2.png) [@sven-abx](https://forum.knime.com/u/sven-abx)\
**Post date:** [January 7, 2020, 2:41pm UTC](https://forum.knime.com/t/etl-combine-values-of-2-rows/20280/3 "2020-01-07T14:41:16Z")

</div>

Hi Alexander,

thanks for your help. Your post reminded me to give RowID and Transpose a second try and it worked out. I think I’m on a good way to get my Workflow going to produce the desired outcome.

Thanks 😃

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [July 8, 2020, 2:41am UTC](https://forum.knime.com/t/etl-combine-values-of-2-rows/20280/4 "2020-07-08T02:41:17Z")

</div>

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.