1 Reply Latest reply: Sep 5, 2013 9:05 AM by Gysbert Wassenaar RSS

    Need Help: how to convert row wise data to column data.

    Sushil Kumar

      Hi Experts,

       

      I have one requirement in which i need to convert row wise data to column wise data. for first instance it looks easy but.. i not getting way to resolve it..

       

      My input file is:

      Key1WBSNameKey2
      3140ABC1344
      3141ABC1423
      3141.1ABC 2.51502
      3141.1.1ABC 2.5 - Android1581
      3141.1.2ABC 2.5 - iOS1668
      3141.1.3ABC 2.5 - Unity1755
      3141.2ABC 2.62277
      3141.2.1ABC 2.6 - Android2356
      3141.2.2ABC 2.6 - iOS2449
      1264100SP140_141 Schedule127635
      1264101Kingfisher 3.0 (SP140,K22,SP141/4002)127717
      1264101.1Milestones127799
      1264101.1.1AJ 3.3.2 Thin Client FC127881
      1264101.1.2AJ 3.3.2 Thin Client CS127977
      1264101.1.3About/Config128062
      1264101.1.3.1About/Config FC128144
      1264101.1.3.2About/Config CS128240
      1264101.1.4Notification128325
      1264101.1.4.1Notification FC128407
      1264101.1.4.2Notification CS128495
      1264101.1.5Onboarding128580
      1264101.1.5.1Onboarding FC128662
      1264101.1.5.2Onboarding CS128751
      1264101.1.6Control Panel128836
      1264101.1.6.1Control FC128915
      1264101.1.6.2Control CS129000

      and i need to get output like below:

       

      KeyTask1Task2Task3Task4Task5Key2
      314ABCABCABC 2.5ABC 2.5 - Android 1581
      314ABCABCABC 2.5ABC 2.5 - iOS 1668
      314ABCABCABC 2.5ABC 2.5 - Unity 1755
      314ABCABCABC 2.6ABC 2.6 - Android 2356
      314ABCABCABC 2.6ABC 2.6 - iOS 2449
      126410SP140_141 ScheduleKingfisher 3.0 (SP140,K22,SP141/4002)MilestonesAJ 3.3.2 Thin Client FC 127881
      126410SP140_141 ScheduleKingfisher 3.0 (SP140,K22,SP141/4002)MilestonesAJ 3.3.2 Thin Client CS 127977
      126410SP140_141 ScheduleKingfisher 3.0 (SP140,K22,SP141/4002)MilestonesAbout/ConfigAbout/Config FC128144
      126410SP140_141 ScheduleKingfisher 3.0 (SP140,K22,SP141/4002)MilestonesAbout/ConfigAbout/Config CS128240
      126410SP140_141 ScheduleKingfisher 3.0 (SP140,K22,SP141/4002)MilestonesNotificationNotification FC128407
      126410SP140_141 ScheduleKingfisher 3.0 (SP140,K22,SP141/4002)MilestonesNotificationNotification CS128495
      126410SP140_141 ScheduleKingfisher 3.0 (SP140,K22,SP141/4002)MilestonesOnboardingOnboarding FC128662
      126410SP140_141 ScheduleKingfisher 3.0 (SP140,K22,SP141/4002)MilestonesOnboardingOnboarding CS128751
      126410SP140_141 ScheduleKingfisher 3.0 (SP140,K22,SP141/4002)MilestonesControl PanelControl FC128915
      126410SP140_141 ScheduleKingfisher 3.0 (SP140,K22,SP141/4002)MilestonesControl PanelControl CS129000

       

      Please help me out to get the solution.

       

      Thanks in Advance

      Regards

      Sushil