how to join excel rows from two files into one

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

Welcome to the forum @Nirdoshdsyr.

I think you’re looking for the Concatenate node.

2 Likes

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

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.

Thanks iCFO, will try the same

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