4 Replies Latest reply: Aug 22, 2013 4:26 AM by Sankar ganesh RSS

    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:

       

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

                                            

       

      Table2:

       

      DateF1F2F3F4
      5/8/2013ab
      6/8/2013cd
      7/8/2013ef
      8/8/2013gh
      9/8/2013ijk
      10/8/2013lmno

       

       

      Thanks,

      Sankar