11 Replies Latest reply: Feb 23, 2017 7:53 AM by Sunny Talwar RSS

    How to Map fields combined by comma separator

    Vijay Malaisamy

      Hi,

          

      I have the following data in Table 1,Table 2 in excel sheet,

       

      Table 1:

      EmployeeIDSkillIDRating
      91,2,3Intermediate
      82,5,1Expert
      101,4,3Basic

       

      Table 2:

      SkillIDSkillName
      1C#
      2AngularJS
      3HTML5
      4JQuery
      5QlikView

       

      From the above two tables we want to map SkillID from Table1 with SkillName in Table2. But the problem is, in Table1 SkillID is combined by 3 fields.

      For e.g. EmpoyeeID 9 knows three Skills(C#,AngularJS,HTML5) but all those are combined in same column. So we need to seperate the commas and map them with Table 2 SkillName or is there any way to map without removing those commas with SkillName field?

       

      Regards,

      Vijay.M