Merge Company Data

Hi All,

I have been assigned the task to merge two company’s data .

I have to ask how can i achieve this even after following all the validations and records having same data must not be imported ?

Does this can be achieved by using Definition Group ??

Hi Lalit,

Please use virtual company accounts. Please refer below link

By using Virtual Company account,only the data will be shared . But i want to merge two company’s data into one …

How can i achieve this ??

Hi Lalit,

By writing below piece of code it mayhelp you;

table1 tabledestination,tablecopy;

select firstonly tablecopy;