How to repeat all row based on another table

[Suseendran]

Hi,

Please help me the below activity.

Input
Data 1
Data 2
Data 3
Data 4

Status
Started
Not Started
Completed

expected output

Input	Status
Data 1	Started
Data 1	Not Started
Data 1	Completed
Data 2	Started
Data 2	Not Started
Data 2	Completed
Data 3	Started
Data 3	Not Started
Data 3	Completed
Data 4	Started
Data 4	Not Started
Data 4	Completed

Please suggest which node is suitable for this activity

[aworker]

Hi @Suseendran & welcome to the KNIME forum

Amazingly the solution of the last challenge of current KNIMEit contest is the solution to your question:

Solutions to "Just KNIME It!" Challenge 04 - Season 2

As always on Tuesdays, here’s the solution to last week’s Just KNIME It! challenge! Just like in a few of the solutions above, this one also relies heavily on the Cross Joiner node . Had you ever used this node before? Pretty costly and yet very powerful – great for applications where the data is not very large, which is the case here. We hope you enjoyed this challenge and hope to see you tomorrow for a new one!

Challenge 4 - Spread yearly values across months – knime

A -Cross Joiner- node should do the job.

Hope it helps.

Best
Ael

[HeatherPikairos]

Hi @Suseendran Welcome to the forum!

You can use the Cross Joiner node for this! I just made the workflow with your data:

Here is the workflow:

20230426 Pikairos Cross Joiner – heatherpikairos

Best Regards
Heather