How to add fields dynamically in the script

[sankar_ganesh]

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

[Gysbert_Wassenaar]

See the attached example.

[sankar_ganesh]

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 ?

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[sankar_ganesh]

Thanks Wassenaar, this is exactly what i wanted !!