Forum Discussion

mkramer's avatar
mkramer
New Contributor
8 years ago

Consolidating Multiple Table Rows to Single Row

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 ar...
transform
kumar's avatar
kumar
New Contributor II
8 years ago

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.