How to repeat all row based on another table

Hi,

Please help me the below activity.

Input
Data 1
Data 2
Data 3
Data 4

Status
Started
Not Started
Completed

expected output
image

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

Hi @Suseendran & welcome to the KNIME forum

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

A -Cross Joiner- node should do the job.

Hope it helps.

Best
Ael

3 Likes

Hi @Suseendran Welcome to the forum!

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

image

Here is the workflow:

Best Regards
Heather

3 Likes

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