Forum Discussion

jnorth's avatar
jnorth
Regular Visitor
8 years ago

How to merge a column data into a specific column

Hello Experts,

I want the values of this "Blank" column to show within "Marketing". How can I do this?

This data is coming in from Salesforce. Both "Marketing" and "Sales" is referenced under my "Lead_Source_Type" field. But I also get these leads under a "Blank" column. Since getting this fixed in Salesforce is most likely not an option, how can I create a function that takes these leads under the "Blank" column and merge as a "Marketing" Lead_source_Type.  

I want the values of this "Blank" column to show within "Marketing"

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi  jnorth,

     

    If I understand your requirement correctly that you want to have a new column that combine the values both the blank column and Marketing column.

     

    You could go to Query Edtior and add a Custom column.

     

     

    If you need additional help please share your expected output.

     

    Best regards,

    Cherry