Inserting new rows into existing table

[danshu09]

Hi All,

My first project in Knime.

I found a topic with the same title but wasn’t able to recreate it.

The OP ran into the same issue as me but they were able to fix it, I cannot.

I simply want to add static rows into a joiner.

When I use concatenate it just puts those rows to the columns right of the joiner table.

They said to do a Table Creator but I didn’t know how to connect the nodes to make it work.

Thanks,
Daniel

[hmfa]

Hi, @danshu09.
Welcome.

Can you explain better what you intend to do. Maybe with example data.

Try this joinner

Joiner Example – kczyran

Regards
Hugo

[iCFO]

Concatenate will add the rows to the bottom if the column names / types / order match.

[danshu09]

[danshu09]

All I am trying to do is to copy the first three rows from one file (headers) and insert them as rows on top of another file (data).

The reason why I am doing this is because the joiner got rid of those rows and I need them back.

[hmfa]

Hi, @danshu09.

To do that, both tables must have the same structure of names and types.

Regards
Hugo

[iCFO]

Can you upload that workflow and de-select “reset workflow” during the export? I think once we see the inputs this would only take a few seconds to do.

Should row 0 actually become the header in KNIME? Then the data rows become the data?

[iCFO]

Sample Workflow.knwf (2.7 MB)

See if this achieves your goal.

[danshu09]

My apologies for the delay.

I was able to make this work by adding a row to my Headers file to match the Headers of the Data file.