Good evening,
An Excel table with PERVASIVE SQL binding with one column per month, that is, 12 columns. In order to better work the data, I need to turn the 12 columns into only 2: - a 1st with the values that were in the 12 columns - a second column with the respective month, that is, before the column title.
Current table:
Al_Cta | MoedCod | TpVal | FlagDC | Month01 | Month02 | Month03
AAAAA | 100 | 20 | 5| 15 | 18 | 16
BBBBB | 200 | 40 | 10| 20 | 21 | 26
CCCCC | 300 | 60 | 15| 40 | 48 | 41
And I want to:
Al_Cta | MoedCod|TpVal | FlagDC | Value | Month
AAAAA | 100 | 20| 5 | 15 | 01
AAAAA | 100 | 20| 5 | 18 | 02
AAAAA | 100 | 20| 5 | 16 | 03
BBBBB | 200 | 40| 10 | 20 | 01
BBBBB | 200 | 40| 10 | 21 | 02
BBBBB | 200 | 40| 10 | 26 | 03
CCCCC | 300 | 60| 15 | 40 | 01
CCCCC | 300 | 60| 15 | 48 | 02
CCCCC | 300 | 60| 15 | 41 | 03
Thank you