Joining tables/ csv files

I'm trying to join tables/csv files in KNIME using joiner node but it seems that the tables are not joining properly and I see values shifting  to unrelated columns

Can somebody suggest which option out of four (inner join, outer join etc) is good in what condition.


Dear Kuldeep, can you provide us with more information, like your data setting or which values were shifting. A small example workflow of the problem is always a huge help.

Best Iris