whats is the difference between merge and join .

Question

Sigiloso · Accepted Answer

said merge requires sorting of data and join doesnt .

Sigiloso · 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.

Sigiloso · 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

Pergunta de entrevista da empresa IQVIA

Respostas da entrevista

Empresas seguidas

Buscas de vagas