Merge join

Even though there is no common field present in two excel sheets can still Merge join Plugin be used?

Hi Pradnya,
Generally we specify common key fields in Merge join,
But t yes, merge join can be used without specifying key fields to match. The result will be like the CARTESIAN JOIN or the CROSS JOIN.