topic Re: How to add fields dynamically in the script in QlikView

How to add fields dynamically in the script

sankar_ganesh — Thu, 15 Aug 2013 13:58:08 GMT

Hello,

I want to convert the Table1 into Table2 , as given below. This needs to create fields dynamically in Table2 based on the counts of 'Code' aggr. by 'Date' in Table1.

Does anyone have any idea to implement this..

Table1:

Date	Code
5/8/2013	a
5/8/2013	b
6/8/2013	c
6/8/2013	d
7/8/2013	e
7/8/2013	f
8/8/2013	g
8/8/2013	h
9/8/2013	i
9/8/2013	j
9/8/2013	k
10/8/2013	l
10/8/2013	m
10/8/2013	n
10/8/2013	o

Table2:

Date	F1	F2	F3	F4
5/8/2013	a	b
6/8/2013	c	d
7/8/2013	e	f
8/8/2013	g	h
9/8/2013	i	j	k
10/8/2013	l	m	n	o

Thanks,

Sankar

Re: How to add fields dynamically in the script

Gysbert_Wassenaar — Thu, 15 Aug 2013 15:55:55 GMT

See the attached example.

Re: How to add fields dynamically in the script

sankar_ganesh — Thu, 15 Aug 2013 19:52:16 GMT

Hello Gysbert,

thanks for you help. Here the important point to be noted is that the no. of fields in Table2 depends on the max. no. of count of code per day.

in the above example,at any day if i get max. count of codes per day is 6 then fields F1,F2...F6 need to be created, if it is 20 on the next day then F1..F20 have to be created. is it possible ?

Re: Re: How to add fields dynamically in the script

Gysbert_Wassenaar — Tue, 20 Aug 2013 17:13:22 GMT

See attached qvw

Re: How to add fields dynamically in the script

sankar_ganesh — Thu, 22 Aug 2013 08:26:54 GMT

Thanks Wassenaar, this is exactly what i wanted !!