Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How do I split a column according to another column?

I have this table here I am trying to split the "config_customfield" column into two columns using "Est. Renew $" and "Renewal Term" as column headers and "User_Defined_Field_Value" as the val...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

Tring to understand your requirements.

Do you want to replace Null with the values from the config_recid col?

 

Thanks,

Tejaswi

Anonymous's avatar
Anonymous
Not applicable
7 years ago

No,  referring to the original post.  I need to split the config_customfield column.  I need my table to look like this.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

     

    And from where is your this data coming from? I dont see i in your screenshots.

     

     

    Thanks,

    Tejaswi

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      thats randomly inserted data into excel.  other configs not in the original post have different numerical values.  I was expressing this condition.  Each configuration is denoted by a RecID and will have an Est. Renew $ value as well as a Renewal Term.  There are ony 5 options for Renewal Term 0-5 years.  It is also possible to have duplicate Est. Renew values but they are irrelevant to each other

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous ,

         

        Would it be possible to provide some sample data in excel?

         

        I want to recreate the issue first.

         

        Thanks,

        Tejaswi