I see the field names contain the year and phase information.
You might need a crosstable load to get this data into a more manageable fact style table. Check out crosstable loads in the manual. If you need more help on the crosstable, I suggest that you post some sample data here. The attach file option is available if you click on "Use advanced editor" on the reply window.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
this is only good for excel for example and not when connecting directly to the database. i want to do a crosstable in the script that already pull if is possible. my source is not Table Files, is ODBC.