Help transforming the input table

mrthomasshelby — Mon, 19 Mar 2018 13:54:30 GMT

Hello all!

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

No	R1	Units	Price
No	R1	Units	150m	300m	600m	900m	1500m	2500m
1	½	LS	5	10	15	20	25	30
2	¼	LS	10	15	20	25	30	35
3	¾	LS	15	20	25	30	35	40

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

Name	S1	S2	S3	Units	Price
//This field should have the excel filename in all the rows//	//This field should have the excel file tab name in all the rows//	½	150m	LS	5
		½	300m	LS	10
		½	600m	LS	15
		½	900m	LS	20
		½	1500m	LS	25
		½	2500m	LS	30
		¼	150m	LS	10
		¼	300m	LS	15
		¼	600m	LS	20
		¼	900m	LS	25
		¼	1500m	LS	30
		¼	2500m	LS	35
		¾	150m	LS	15
		¾	300m	LS	20
		¾	600m	LS	25
		¾	900m	LS	30
		¾	1500m	LS	35
		¾	2500m	LS	40

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‌

Re: Help transforming the input table

sunny_talwar — Mon, 19 Mar 2018 14:00:54 GMT

I think you need this

The Crosstable Load

topic Re: Help transforming the input table in QlikView

Help transforming the input table

Re: Help transforming the input table