Hi. I'm not sure I would create a complex transformation and etl with R or Python but yes you can use more than 1 table. You just need to take a look at PowerQuery code to modify the parameters. You can activate "Formula Bar" to check the code. That might help next time. Let's check how it works by default taking one "dataset"
R.Execute( #"Previous Step", [dataset=#"Previous Step"] )
If you want to use another frame there, you can just specify it in the powerquery line like:
R.Execute(#"Previous Step", [dataset=#"Previous Step", dataset2=#"Other Step", dataset3=#"Other Table"])
That way the script you will write latter know more than one frame. You will be able to combine in any way you want. I'm not an R developer, but here you have an example:
df_A <- dataset
df_B <- dataset2
df_C <- dataset3
df_temp <- rbind(df_C, df_B, df_A)
output <- .....
You can read a more detailed answer here: https://stackoverflow.com/questions/44897796/operations-on-multiple-tables-datasets-with-edit-querie...
I hope that helps,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!