whats is the difference between merge and join .

Question

Anonymous · Accepted Answer

said merge requires sorting of data and join doesnt .

Anonymous · Answer

Using join you can split lines (duplicate).
For example, you have AETERM in Adverse Event, where AETERM = "headtoothache". It's 2 independent DECOD, and if you need to control it by MedDRA dictionary you need to split lines where AETERM in both lines equal to 'headtoothache'  but AEDECOD in the first line equal to 'HEADACHE' and 'TOOTHACHE' in the second line.

Anonymous · Answer

Merge:Merge is combining process which combine column wise  i.e vertically, add different kind of variable names and datatypes, and

Join: join is adding process which add rows wise i.e horizontal, add only same kind of variable names and datatypes.

Rahul Bandaru · Answer

Both are horizontal combination of data set values. where, merge needs the data set to be sorted before combining. And join combines data set values based on Cartesian product.

IQVIA

IQVIA Interview Question

Interview Answers

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches