INTERNET APPLICATION DEVELOPMENT
MID MARKET ERP DEVELOPMENT
By Sheila Zhang
GLAFS table is my favorite data table in the Sage 300 ERP database. It was designed to list all fiscal periods of a fiscal year with 15 fields or columns. Here are two ways to transpose the period’s columns to rows.
Method 1:
Method 2:
For further details of UNPIVOT function, please click here.
This is what the results from both statements look like: