Adding more ports to R node

[thentangler]

Is there a way to add more ports to the R node?
I have 2 tables that I want to transform using R code

[eamendola]

Hi @thentangler

Do your tables have the same structures? I would suggest to concatenate both Query readers into one table (Concatenate node), before passing it to the Table to R node, then finally pass that one output to the R to R.

I can’t provide you an example right now because a don’t have those extensions installed. I hope my suggestion makes sense.

[mlauber71]

@thentangler you could add another table to R with this node (example here)

Add Table To R

Or you could save data in a parquet file or SQLite database and use that in the R node (and also bring data back to knime)

use R library(arrow) to read parquet file into KNIME – mlauber71

Create a SQLite table with R (and manipulate data) – mlauber71

[thentangler]

@mlauber71 and @eamendola thank you for these suggestions. It’s working now!