Apex Code Development You need to sign in to do that
Don't have an account?
Import from Excel
Hi All,
I have a requirement to import data from excel sheet. the Sheet will have data similar to the below one,
As you see, I need to map two (or more) Contacts to the same account in a row. For Eg, 2nd column has 2 contacts. So, I need to create 2 list records for 1 row and at the end list should have 6 rows (2 contacts for each accounts).
If I iterate the row using 'for' loop, I can able to map only One contact not two. So, I end up adding only 3 rows. Is there a way we can achieve this.?
Thanks,
Vignesh
I have a requirement to import data from excel sheet. the Sheet will have data similar to the below one,
As you see, I need to map two (or more) Contacts to the same account in a row. For Eg, 2nd column has 2 contacts. So, I need to create 2 list records for 1 row and at the end list should have 6 rows (2 contacts for each accounts).
If I iterate the row using 'for' loop, I can able to map only One contact not two. So, I end up adding only 3 rows. Is there a way we can achieve this.?
Thanks,
Vignesh
I haven't seen it done, I usually think of each row as its own record in SF. When I have similar requirements I just make sure all the contacts are mapped to the correct account ID number and I give each contact a row of its own, again I like to think of each row being its own record in SF. If I'm correct in my way of thinking then you would be combining two contacts together and associating the merged contacts with an account which I'm guessing wont work. To sum it all up if I were you i would just make sure each contact is mapped to the correct Account ID number and give each contact a row of its own with the desired account ID.