Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

sushil353
Honored Contributor II

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

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

See attached qvw


talk is cheap, supply exceeds demand
1 Reply
MVP & Luminary
MVP & Luminary

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

See attached qvw


talk is cheap, supply exceeds demand