pt
0 Followers · 0 Following
  • Joined on 2019-12-31
Repositories
29
 Projects Packages Public Activity Starred Repositories
1
pt pushed to master at pt/pivot_forecast 2020-11-09 23:04:02 -05:00
7e3354824c forgot the commas
pt pushed to master at pt/pivot_forecast 2020-11-09 13:16:20 -05:00
17895dc443 MIT license
pt pushed to master at pt/pivot_forecast 2020-11-08 22:44:29 -05:00
9e37284305 update problems, and remove old files
pt pushed to master at pt/pivot_forecast 2020-11-08 22:30:25 -05:00
babdd3c8a7 update progress on baseline
pt pushed to master at pt/pivot_forecast 2020-11-08 22:20:19 -05:00
79d3a7751c move script to generate sql statements
pt pushed to master at pt/pivot_forecast 2020-11-08 22:16:42 -05:00
06488cae18 forecaste name, insert statement, delete statement , and orders cutuff
pt pushed to master at pt/pivot_forecast 2020-11-08 22:15:28 -05:00
8da4a929e0 remove references to old files
pt pushed to master at pt/pivot_forecast 2020-11-08 21:04:54 -05:00
25eea2ac13 create the final baselin
pt pushed to price_list at pt/VBA 2020-11-06 14:48:56 -05:00
0143a891bb rework the coloring a bit
pt pushed to master at pt/pivot_forecast 2020-11-06 00:24:21 -05:00
2610228c06 rename stuff, build shell script, include ignore file so routes sql is ignored for clones
pt pushed to master at pt/pivot_forecast 2020-11-06 00:12:10 -05:00
73f7667ef7 get column list for plu to increment year
b6edc4006a comments
Compare 2 commits »
pt pushed to master at pt/pivot_forecast 2020-11-05 23:58:32 -05:00
15b515a5e1 begin unioning in the piece used to plug the remainder of the year to create a full baseline
pt pushed to master at pt/pivot_forecast 2020-11-05 23:50:05 -05:00
fcac081823 add the notion of an appcolumn, and use it to push into variables to generate route sql
pt pushed to master at pt/pivot_forecast 2020-11-05 23:01:07 -05:00
d9bfe43d2e initial select with column list combined with body for ytd
pt pushed to master at pt/pivot_forecast 2020-11-05 22:39:40 -05:00
4b55ab4394 put sql generating statemts into their own folder
pt pushed to master at pt/pivot_forecast 2020-11-05 22:35:44 -05:00
9c9a345f0a move setup sql into a different folder
pt pushed to master at pt/pivot_forecast 2020-11-05 22:32:35 -05:00
d6dbf54ec6 only increment fields by an interval that are actually dates
9e53758fd9 include schema name in table name column
a15d807178 include a reference to corresponding column from the foreign table but that has a different name (like oseas = ssyr from table perd)
0452bde160 sort the columns normally except push the primary key(s) into the first positiong
Compare 4 commits »
pt pushed to master at pt/pivot_forecast 2020-11-04 22:59:04 -05:00
55dcb65a17 new column list to increment date periods
a8419e9fd6 change target name, and exlude gld joins intended for snapping months, that should be done during data prep
Compare 2 commits »
pt pushed to master at pt/pivot_forecast 2020-11-04 22:33:39 -05:00
5134b659c0 rename
pt pushed to master at pt/pivot_forecast 2020-10-30 01:20:01 -04:00
0307fb6c6b notes