Duplicate or copy row while appending values from another table or list into new column and then loop

KNIME Analytics Platform
1

Hi everyone,

I need to accomplish this and it seems easy, but I’m not able to do this. Still new to KNIME but love the tool. Thank you so much for your help!Book1.xlsx|attachment (10.3 KB)

image

2

Hello,

Try the cross join node.

3 Likes
3

Hi @alabamian2,

Try this: KNIME_project7.knwf (12.4 KB)

GL,
Mehrdad

1 Like
4

Hi @rd2575691
I tied regular join and looked for settings…obviously that didn’t work. I’ll try the Cross Joiner node!!! Thank you so much!!

5

Hello @mehrdad_bgh ,
Yes, this totally works. Thank you so much for sharing and hope you have a nice weekend!!

1 Like
6

Hello @alabamian2,

your use case is exactly the one for above mentioned Cross Joiner node :wink:

Br,
Ivan

2 Likes
7

Hi @alabamian2,

Thank you, but Ivan is right you can do this easily with Cross joiner node.
Here is an example for you: KNIME_project7.knwf (7.3 KB)
Sry, my bad.

Mehrdad

3 Likes
8

Hi @mehrdad_bgh,
No no, thank you @mehrdad_bgh. I’m learning from your workflow and loop so thank you. Yes, Cross Joiner worked well for me.
Thank you all!!

2 Likes
9

Hi @alabamian2,

I’m glad to hear that.
I think this will help you with your loop learning process:

Br,
Mehrdad

5 Likes
10

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