Need Help - Create dynamic columns & rows

[#1]

Hello All,

I have requirement to convert the data from Table 1 to Table 2 in QV 11 SR1  as shown in screenshot, number of Rows in Table 1  is dynamic, means column creation of Table 2 in qlikview witll be dynamic as well.

I am really new in Qlikview and will appreciate any guidance.

Thanks,

Pooja

[#2]

Any inputs please ?

[Gysbert_Wassenaar]

It's a very bad idea and I have no idea why you would ever want to do that, but this should do what you want:

T2:

load RowNo() as id, * inline [

Name, Value

Chipset,Chip 1

Chipset,Chip 2

Chipset,Chip 3

Modem,Mod 1

Modem,Mod 2

Wireless,Wir 1

Wireless,Wir 2

];

T3:

load RowNo() as id, Value as Chipset

Resident T2 where Name = 'Chipset';

join(T3)

load RowNo() as id, Value as Modem

Resident T2 where Name = 'Modem';

join(T3)

load RowNo() as id, Value as Wireless

Resident T2 where Name = 'Wireless';

drop field id;

drop table T2;

You can replace the inline load with a load statements that load your Table 1 data.

[#4]

Thanks Gysbert for your response. It will work , if the Name field value are constant.

Solution of this problem become much simpler with  the updatde requirements.

Was able to achieve it by using Pivot Table , Name as Dimension & value as expression.

[jeffmartins]

Hi poojasaxena,

I've had a problem similar with yours about creating fields dynamically and I solved it using the code of the attached file.

Hope this helps you.

Regards