how to join excel rows from two files into one

[Nirdoshdsyr]

Hi

I am new to Knime , I am trying to combine two excel sheets into one row wise, but the joiner nod is joining them column wise

[elsamuel]

Welcome to the forum @Nirdoshdsyr.

I think you’re looking for the Concatenate node.

[Nirdoshdsyr]

Hi Elsamuel
Thanks for quick revert.
Let me explain i have two excel workbooks with data exactly same header, One workbook have 250 rows and second workbook have 200 rows now i need to combine them into new work book where the header remains same and all the 450 rows are there

[iCFO]

Try @elsamuel’s suggestion for the “Concatenate” node. If your headers are the same, then it will combine rows into a combined longer table. After that, you can write to excel.

[Nirdoshdsyr]

Thanks iCFO, will try the same