Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
mrthomasshelby
Contributor III

Help transforming the input table

Hello all!

I have a table as shown below in an excel file:

NoR1UnitsPrice
150m300m600m900m1500m2500m
1½LS51015202530
2¼LS101520253035
3¾LS152025303540

I need to transform the above table into the table as shown below:

       

NameS1S2S3UnitsPrice
//This field should have the excel filename in all the rows////This field should have the excel file tab name in all the rows//½150mLS5
½300mLS10
½600mLS15
½900mLS20
½1500mLS25
½2500mLS30
¼150mLS10
¼300mLS15
¼600mLS20
¼900mLS25
¼1500mLS30
¼2500mLS35
¾150mLS15
¾300mLS20
¾600mLS25
¾900mLS30
¾1500mLS35
¾2500mLS40

Although I have been using Qlik View for sometime now, I have came across a table transformation with merged labels and converting column to rows scenario. Please help me out with this! TIA! stalwar1

1 Reply
Highlighted

Re: Help transforming the input table

I think you need this

The Crosstable Load