• Joined on 2019-12-31
63 contributions in the last 12 months
JulAugSepOctNovDecJanFebMarAprMayJunMonWedFri
Less
More
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
pt pushed to master at pt/pivot_forecast 2020-10-23 00:19:43 -04:00
e12a96df2e comments on work done
pt pushed to master at pt/pivot_forecast 2020-10-23 00:16:59 -04:00
d3c9b627e2 start working on initial baseline rollout
pt pushed to master at pt/pivot_forecast 2020-10-22 23:56:48 -04:00
7abf659939 basic tables setup
pt pushed to master at pt/pivot_forecast 2020-10-22 23:36:48 -04:00
34af4abfac format
pt pushed to master at pt/pivot_forecast 2020-10-22 23:35:18 -04:00
dbee083970 update readme to reflect work done so far
pt pushed to master at pt/pivot_forecast 2020-10-22 23:09:37 -04:00
fb76e42e42 update temp, it just mirrors build query for testing
pt pushed to master at pt/pivot_forecast 2020-10-22 23:08:17 -04:00
0f698d5621 include foreign key setup
ba93b6b84e replace hardcoded table name to derive from target meta
Compare 2 commits »