Posts by deathseeker • 11 points
2 posts
-
1
votes0
answers45
viewsQ: Normalize database (unpivot columns per month)
Good night, An Excel table with PERVASIVE SQL connection with one column per month, that is, 12 columns. In order to better work the data, I need to transform the 12 columns into only 2: - a first…
-
0
votes1
answer247
viewsQ: 12 month columns => 1 value column + 1 month column
I have a table with SQL connection (PERVASIVE) with a column for each month, that is, 12. In order to better work the data, I need to transform the 12 columns in only 2... a 1st with the values that…
sqlasked deathseeker 11