2 Replies Latest reply: Apr 17, 2018 1:02 AM by Rahul Goyal RSS

    Advance search in a string to map multiple values

    Rahul Goyal

      Hi Folks,

       

      Thanks for sparing some time to help me here.

      Here is the problem statement where I am stuck with and looking for some help to move forward.

       

      I have one field 'Description_C' which has some values in it (these are various reasons separated by coma) -

       

      Access type change

      Access type change, POP Details change

      POP Details change, Interface/connector change

       

      I would need to map these reasons in an another column 'Calc_Reason' under some category. For example -

      so these above 3 entries would result into 5 combination of mapping values as stated below:

       

       

      Description_CCalc_Reason
      Access Type ChangeAccess Type Change
      Access type change, POP Details changeAccess Type Change
      Access type change, POP Details changePOP Details change
      POP Details change, Interface/connector changePOP Details change
      POP Details change, Interface/connector change

      Interface/connector change