pt
0 Followers · 0 Following
  • Joined on 2019-12-31
Repositories
29
 Projects Packages Public Activity Starred Repositories
1
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
pt pushed to master at pt/pivot_forecast 2020-10-30 00:56:55 -04:00
df381ee313 push column list into a text variable for downstream use
pt pushed to master at pt/dotnet_runner 2020-10-29 13:04:06 -04:00
ccab5fb1e2 add to ignore
pt pushed to price_list at pt/VBA 2020-10-28 11:22:24 -04:00
9dcf8ac310 get rid of suffix column and include use accs instead of kit
pt pushed to master at pt/pivot_forecast 2020-10-28 00:03:17 -04:00
270eb46123 initial work on column builder, driven by shell
pt pushed to master at pt/pivot_forecast 2020-10-27 23:48:55 -04:00
1bc21d9940 notes on progress
pt pushed to master at pt/pivot_forecast 2020-10-27 23:47:24 -04:00
11a8ff2c68 notes
pt pushed to master at pt/pivot_forecast 2020-10-27 23:44:18 -04:00
975ea43b65 initial work on parameterizing baselining process
pt pushed to master at pt/pivot_forecast 2020-10-27 23:12:14 -04:00
6d2cacb726 change the baseline version names