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

transform

1 Reply

  • 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.