โ02-18-2018 10:26 AM
I donโt know why Iโm having such trouble with this task but I canโt seem to do this. Iโm using a REST Get against our CRM system to extract the phone numbers related to a contact ID. Since there are four distinct types of phone numbers that can exist per contact, I end up with four rows per contact ID.
In reality, Iโd like one row for the contact but with one column for each phone type. Anyone know how to do this? Help is always appreciated. (see image for my starting point).
Thanks.
Mike
โ02-19-2018 10:57 PM
Hi Mike,
There might be some better solution for this scenario. but below is one of the solution.
I have added one aggregate snap and get the unique_contact for each id. After that i have removed the none(assumed itโs equal to null) and concatenation symbol in the mapper.