{ "auto_complete": { "selected_items": [ [ "curre", "currencyid" ], [ "assi", "assign.to.envir" ], [ "k", "kCols.ts" ], [ "strea", "StreamLength" ], [ "DT.", "DT.plot.agg" ], [ "Orc", "Orchard" ], [ "Orch", "Orchard_vs_Spotify" ], [ "Stre", "StreamLength" ], [ "Or", "Orchard" ], [ "orc", "orchard_streams" ], [ "DT", "DT.data.Total_usage" ], [ "perc.songs", "perc.songs_skipped" ], [ "join", "join.cols.giv" ], [ "class.", "classes.r" ], [ "join.c", "join.cols.rec" ], [ "join.", "join.cols.rec" ], [ "all", "all_streams" ], [ "test", "test1" ], [ "tria", "type_of_trial" ], [ "count", "countryGrp" ], [ "DT.pl", "DT.plot" ], [ "date", "date_file" ], [ "DT.bre", "DT.breakage" ], [ "dow", "downloadFiles" ], [ "datafil", "datestamped.filenames" ], [ "rev", "revshareFiles" ], [ "dates", "dateFromSpotifyFile" ], [ "revs", "revshareFiles" ], [ "dates.rev", "dates.revshareFiles" ], [ "Ven", "'Vendor" ], [ "nms.", "nms.all.list" ], [ "break", "breakageFiles" ], [ "of", "namesOfFiles.xls" ], [ "acti", "activity_month" ], [ "setkey", "setkeyIfNot" ], [ "Act", "Activity_Month" ], [ "act", "activity_month_date" ], [ "file", "filetype" ], [ "acit", "activity_month_date" ], [ "DT.sp", "DT.Spot_ASR_Revenue.molt" ], [ "kC", "kCols.DateGrp" ], [ "T", "TOTAL" ], [ "G", "Grand" ], [ "TR", "transac_type_abbr" ], [ "Group", "Grouping2" ], [ "DT.s", "DT.Spot_ASR_Revenue" ], [ "XL", "XLStoDT" ], [ "ms", "msg.email" ], [ "sche", "schema" ], [ "cluster", "cluster.out" ], [ "upda", "updateDeNormTable" ], [ "fold", "folder_rel_to_src" ], [ "tbl.f", "tbl.fact" ], [ "fact_", "fact_analytics" ], [ "prod", "production" ], [ "gsub", "gsubQry" ], [ "QRY", "QRY.create" ], [ "match", "extractMatch" ], [ "updat", "Update" ], [ "proj", "projName" ], [ "DT.val", "DT.validate.fact" ], [ "DT.va", "DT.validate.fact" ], [ "DT.r", "DT.rowcounts.fact" ], [ "aggregated", "aggregated_analytics" ], [ "cols", "colsToCompare.ratio" ], [ "DT.row", "DT.rowcounts.aggd" ], [ "do", "download_activity_date" ], [ "qry", "qry_03_AN" ], [ "tbl", "tbl.tmp" ], [ "schem", "schemaPaste" ], [ "failed", "failedValidation" ], [ "produc", "production.fact_analytics" ], [ "DT.vali", "DT.validate.fact" ], [ "sch", "schema" ], [ "dayi", "dayidTodate" ], [ "day", "dayidTodate" ], [ "mind", "minDayIdUsing" ], [ "st", "storeids.to.check" ], [ "production.", "production.fact_analytics" ], [ "aggreg", "aggregated_analytics" ], [ "schema.", "schema.new" ], [ "aggre", "aggregated_analytics" ], [ "tb", "tbl.tmp" ], [ "sc", "schema" ], [ "sce", "schemaPaste" ], [ "buck", "bucket.todelete" ], [ "has", "hasRows" ], [ "conf", "confirm_dates" ], [ "verbose", "verboseMsg" ], [ "verbo", "verboseMsg" ], [ "tr", "truncate.if.exist" ], [ "del", "delim" ], [ "is.c", "is.char_of_length1" ], [ "is", "is_l1" ], [ "trac", "track_type" ], [ "clu.", "cluster.out" ], [ "remove", "removeNA" ], [ "files", "files_to_source" ], [ "grol", "grossCol.reported" ], [ "DT.GL_fo", "DT.GL_forecasted.merged" ], [ "gro", "grossCol.reported" ], [ "DT.re", "DT.reported" ], [ "igno", "ignoreCols" ], [ "ver", "verbose.qry.oa" ], [ "table", "tableExists" ], [ "orig", "orig.cluster" ], [ "blan", "blankCols" ], [ "new", "newCols" ], [ "cr", "current" ], [ "folder", "folder.zArchive" ], [ "exp", "expectedCols" ], [ "expe", "expectedRows" ], [ "not", "notifyRick.FileIngestionFailed" ], [ "expect", "expectedCols" ], [ "DT.m", "DT.monthlyforecasts" ], [ "days", "daysFromTarget" ], [ "round", "roundOutToX" ], [ "fake", "fakeToday" ], [ "fore", "forecasted_gross" ], [ "DT.cl", "DT.cleaned.aggd" ], [ "store", "store_musicbucket" ], [ "run", "thisRunIsAForecast" ], [ "store_", "store_musicsuperbucket" ], [ "add", "addSuperBucket_" ], [ "kc", "kCols.smry" ], [ "DT.clea", "DT.cleaned" ], [ "ignore", "ignoreFails" ], [ "TRE", "TRUE" ] ] }, "buffers": [ { "file": "/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables/track-artist from reportsAR.r", "settings": { "buffer_size": 654, "line_ending": "Unix" } } ], "build_system": "", "build_system_choices": [ ], "build_varint": "", "command_palette": { "height": 392.0, "last_filter": "reve", "selected_items": [ [ "reve", "File: Reveal" ], [ "rext", "Set Syntax: R Extended" ], [ "rex", "Set Syntax: R Extended" ], [ "revea", "File: Reveal" ], [ "path", "File: Copy Path" ], [ "push", "Git: Push" ], [ "qui", "Git: Quick Commit Current File" ], [ "sql", "Set Syntax: SQL" ], [ "quic", "Git: Quick Commit Current File" ], [ "ren", "File: Rename" ], [ "comcu", "Git: Quick Commit Current File" ], [ "pah", "Package Control: Add Channel" ], [ "enh", "Set Syntax: Enhanced-R" ], [ "rap", "R Application Switch" ], [ "word", "Word Wrap: Toggle" ], [ "wor", "Word Wrap: Toggle" ], [ "rev", "File: Reveal" ], [ "addcu", "Git: Add Current File" ], [ "git qui", "Git: Quick Commit Current File" ], [ "pull", "Git: Pull" ], [ "file", "File: Copy Name" ], [ "psu", "Git: Push" ], [ "qu", "Git: Quick Commit Current File" ], [ "pus", "Git: Push" ], [ "pat", "File: Copy Path" ], [ "pul", "Git: Pull" ], [ "quci", "Git: Quick Commit Current File" ], [ "ra", "R Application Switch" ], [ "ush", "SublimeREPL: Shell" ], [ "dele", "File: Delete" ], [ "del", "File: Delete" ], [ "psuh", "Git: Push" ], [ "puh", "Git: Push" ], [ "quick", "Git: Quick Commit Current File" ], [ "disable pack", "Package Control: Disable Package" ], [ "disa", "Package Control: Disable Package" ], [ "check", "Git: Checkout New Branch" ], [ "git com cur", "Git: Quick Commit Current File" ], [ "curr", "Git: Add Current File" ], [ "git comcu", "Git: Quick Commit Current File" ], [ "name", "File: Copy Name" ], [ "qucur", "Git: Quick Commit Current File" ], [ "com cu", "Git: Quick Commit Current File" ], [ "quicad", "Git: Quick Add" ], [ "move", "File: Move" ], [ "PAT", "File: Copy Path" ], [ "git comm", "Git: Commit" ], [ "synshe", "Set Syntax: Shell Script (Bash)" ], [ "shel", "SublimeREPL: Shell" ], [ "fil", "File: Copy Name" ], [ "nh", "Set Syntax: HTML" ], [ "nam", "File: Copy Name" ], [ "fin", "File: Copy Name" ], [ "comm", "Git: Commit" ], [ "add cu", "Git: Add Current File" ], [ "enha", "Set Syntax: Enhanced-R" ], [ "checkou", "Git: Checkout New Branch" ], [ "filena", "File: Copy Name" ], [ "com file", "Git: Quick Commit Current File" ], [ "quc", "Git: Quick Commit Current File" ], [ "qucomf", "Git: Quick Commit Current File" ], [ "comf", "Git: Quick Commit Current File" ], [ "wo", "Word Wrap: Toggle" ], [ "qucf", "Git: Quick Commit Current File" ], [ "commfil", "Git: Quick Commit Current File" ], [ "filen", "File: Copy Name" ], [ "branch", "Git: Checkout New Branch" ], [ "new br", "Git: Checkout New Branch" ], [ "branc", "Git: Checkout New Branch" ], [ "copy", "File: Copy Name" ], [ "rena", "File: Rename" ], [ "add", "Git: Add Current File" ], [ "RENA", "File: Rename" ], [ "ADD", "Git: Add Current File" ], [ "copnam", "File: Copy Name" ], [ "q", "Git: Quick Add" ], [ "renam", "File: Rename" ], [ "rapp", "R Application Switch" ], [ "rep", "SublimeREPL: PHP" ], [ "enhg", "BracketHighlighter: Select Next Attribute (right)" ], [ "en", "Set Syntax: Enhanced-R" ], [ "WOR", "Word Wrap: Toggle" ], [ "pu", "Git: Push" ], [ "r", "R Application Switch" ], [ "cop", "File: Copy Name" ], [ "delet", "File: Delete" ], [ "RA", "R Application Switch" ], [ "REV", "File: Reveal" ], [ "COPNA", "File: Copy Name" ], [ "ENH", "Set Syntax: Enhanced-R" ], [ "QUIC", "Git: Quick Commit" ], [ "co", "File: Copy Name" ], [ "COP", "File: Copy Name" ], [ "oath", "File: Copy Path" ], [ "copy na", "File: Copy Name" ], [ "ite", "Indentation: Convert to Spaces" ], [ "git pu", "Git: Pull" ], [ "diff", "Git: Diff Current File" ], [ "filenam", "File: Copy Name" ], [ "disab", "Package Control: Disable Package" ], [ "enable", "Package Control: Enable Package" ], [ "SQL", "Set Syntax: SQL" ], [ "sq", "Set Syntax: SQL" ], [ "ql", "Git: Quick Log" ], [ "r app", "R Application Switch" ], [ "enah", "Set Syntax: Enhanced-Rd" ], [ "late", "Set Syntax: LaTeX" ], [ "enabl", "Package Control: Enable Package" ], [ "git add", "Git: Add Current File" ], [ "yaml", "Set Syntax: YAML" ], [ "ya", "Set Syntax: YAML" ], [ "Q", "Git: Quick Commit" ], [ "git ad", "Git: Add Current File" ], [ "g quick", "Git: Quick Commit" ], [ "git qu", "Git: Quick Commit" ], [ "git pus", "Git: Push" ], [ "quic ", "Git: Quick Commit" ], [ "gi qui", "Git: Quick Commit" ], [ "git push", "Git: Push" ], [ "git q", "Git: Quick Commit" ], [ "Rap", "R Application Switch" ], [ "wro", "Word Wrap: Toggle" ], [ "git diff", "Git: Diff Current File" ], [ "git com", "Git: Commit" ], [ "package", "Package Control: List Packages" ], [ "upgra", "Package Control: Upgrade/Overwrite All Packages" ], [ "upgr", "Package Control: Upgrade Package" ], [ "install", "Package Control: Install Package" ] ], "width": 521.0 }, "console": { "height": 126.0, "history": [ "subprocess.Popen([Rscript, '-e', 'args(' + 'as.data.table' + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.table' + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')', '--default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', '\"args(' + func + ')\"'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', '\"args(' + func + ')\" --default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ') --default-packages=\"data.table,ggplot2\"'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ') --default-packages=data.table,ggplot2'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args + '', stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args + \"\", stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args = [Rscript, '-e', 'args(' + func + ')']", "args", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args =[Rscript, '-e', 'args(' + func + ') --default-packages=data.table,ggplot2']", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.table' + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + 'data.frame' + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen([Rscript, '-e', 'args(' + func + ')'], stdout=subprocess.PIPE).communicate()[0]", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "import subprocess", "subprocess.Popen(args, stdout=subprocess.PIPE).communicate()[0]", "args", "args = [Rscript, '-e', 'args(' + func + ')']", "args <- [Rscript, '-e', 'args(' + func + ')']", "[Rscript, '-e', 'args(' + func + ')']", "output", "output = mycheck_output([Rscript, '-e', 'args(' + func + ')'])", "plat = sublime.platform()", "Rscript = \"Rscript\"", "Rscript = get(plat, \"Rscript\", \"Rscript\")", "plat", "help", "?", "{", "def get_Rscript():", "Rscript = get_Rscript()", "print(func in container)", "func", "func = m.group(1)", "print(func in container)", "m.group(1)", "m.group", "view.set_status(\"Enhanced-R\", \"\")", "not m", "if not m: return", "m", "m = re.match(r\".*?([a-zA-Z0-9.]+)\\($\", contentb)", "import re", "m = re.match(r\".*?([a-zA-Z0-9.]+)\\($\", contentb)", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "contentb", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "point", "point = view.sel()[0].end() if view.sel() else 0", " point = view.sel()[0].end() if view.sel() else 0", "point", "contentb", "contentb = view.substr(sublime.Region(view.line(point).begin(), point))", "sel[0].begin() != sel[0].end()", "len(sel)", "if len(sel)!=1: return", "sel = view.sel()", "this_row = view.rowcol(point)[0]", "sel[0].end()", "sel[0].begin()", "sel[0]", "len(sel)", "sel", "sel'", "sel = view.sel()", "this_row", "this_row = view.rowcol(point)[0]", "not view.score_selector(point, \"source.r\")", "view.score_selector(point, \"source.r\")", "point", "point = view.sel()[0].end() if view.sel() else 0", "import urllib.request,os; pf = 'Package Control.sublime-package'; ipp = sublime.installed_packages_path(); urllib.request.install_opener( urllib.request.build_opener( urllib.request.ProxyHandler()) ); open(os.path.join(ipp, pf), 'wb').write(urllib.request.urlopen( 'http://sublime.wbond.net/' + pf.replace(' ','%20')).read())" ] }, "distraction_free": { "menu_visible": true, "show_minimap": false, "show_open_files": false, "show_tabs": false, "side_bar_visible": false, "status_bar_visible": false }, "expanded_folders": [ "/Users/rsaporta/git/orch/src/DeNormalizing", "/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables", "/Users/rsaporta/git/orch/src/DeNormalizing/supportFns", "/Users/rsaporta/git/orch/notes/DeNormalizing", "/Users/rsaporta/git/orch/plots/DeNormalizing", "/Users/rsaporta/git/orch/out/DeNormalizing" ], "file_history": [ "/Users/rsaporta/Desktop/art_relations.track_artist.view.lookml", "/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables/yr_wk_to_date.r", "/Users/rsaporta/git/!Projects/DeNormalizing.sublime-project", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/fa_errors_view_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/02_AC populate_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/03_AC update_aggregated_accounting_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/02_AN populate_aggregated_analytics_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_product_label_view_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_product_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_product_view_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/release_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create All Views.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/period_view_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/03_AN update_aggregated_analytics_snowflake.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Create -- MANUAL SOURCING.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/02_AN populate_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/03_AN update_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/03_AC update_aggregated_accounting.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/02_AC populate_aggregated_accounting.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting/01_AC create_aggregated_accounting.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/transactiontype_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/fa_errors_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/02_AN_b grabErrors_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics/01_AN create_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/store_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/period_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/label_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/comparing fact_analytics_errors.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Views/country_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Analytics/03_AN update_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Analytics/02_AN populate_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Analytics/01_AN create_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Analytics/02b fa_errors_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/fact_analytics_error.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Accounting/02_AC populate_aggregated_accounting.sql", "/Users/rsaporta/gitData/orch/data/TableBasics/dim_day-20140218_1701-250x4.RDS", "/Users/rsaporta/git/misc/rscripts/utils/addColsFrom.r", "/Users/rsaporta/git/StackExchange/!MySOquestions/regex_angled_bracket", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/readSpotifyDataFiles.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/ftp download folder.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/dateFromSpotifyFile.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/cleanRightsholderColumn_.r", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/supportFns/print.datestamped.filenames.r", "/Users/rsaporta/git/orch/ingest/Spotify_Accounting_ETL/ftp_sync/old_files/spotify-revshare-for-downloads-for-theorchard-201312.txt", "/Users/rsaporta/git/orch/ingest/Spotify_Accounting_ETL/ftp_sync/old_files/spotify-revshare-for-theorchard-201312.txt", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/Preferences.sublime-settings", "/Users/rsaporta/development/data.table/src/fread.c", "/Users/rsaporta/development/data.table/R/fread.R", "/Users/rsaporta/git/orch/ingest/Spotify_Accounting_ETL/ftp_sync/spotify-data-for-theorchard-20146.txt", "/Users/rsaporta/git/orch/src/Spotify_Accounting_ETL/Spotify_Raw_Analytics_Files.r", "/Users/rsaporta/git/orch/src/dbconcile/Spot 01 Ingest.r", "/Users/rsaporta/development/deleteme/.git/config", "/Users/rsaporta/git/misc/rscripts/utils/xls/xls_utils.r", "/Users/rsaporta/git/orch/src/spot.cleanGrouping_.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Create All Views.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Views/country_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/Views/release_product_view.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/zArchived/AggregatedTables 140505/populate_aggregated_accounting.sql", "/Users/rsaporta/git/orch/src/chartio/Create GPU Table from analytics.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL Automation - Mgmt Report Ingestion.r", "/Users/rsaporta/git/orch/src/automate new.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt0_a Workspace Setup.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt0_b Keys Folders and Variables.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt0_c Col Name Clean (for restoring backups).r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables_new/UPDATE ioda vendors.r", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/Top Label By Store Group.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zCleanTheseUp/Char Lengths.txt", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_a Import OA from DB Querying Aggregated Tables.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/findMaxDate.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/findDateInterval.r", "/Users/rsaporta/git/orch/src/MGMT_REPORT_only_cluster.out.r", "/Users/rsaporta/git/orch/src/MGMT_REPORT_only_cluster.in.r", "/Users/rsaporta/git/orch/src/MGMT_REPORT_FULL_AUTO.r", "/Users/rsaporta/git/orch/src/DeNormalizing/Create CASE Clause from CSV.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/!01 Create analytics_outter_subqry.r", "/Users/rsaporta/git/orch/src/DeNormalizing/Char Lengths.txt", "/Users/rsaporta/git/orch/src/chartio/SQL Executor.r", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/aggregated_accounting_period_view.txt", "/Users/rsaporta/Downloads/GENRE2_0000_part_00", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/aggregated_accounting_label_view.txt", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/aggregated_accounting_genre_view.txt", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/iTunes RED USA check.r", "/Users/rsaporta/git/orch/src/DeNormalizing/zArchived/AggregatedTables 140520/update agg tables part 2.sql", "/Users/rsaporta/git/orch/src/chartio/Create DS_scratch.GPU from analytics.r", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/03_AN-update_aggregated_analytics (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/03_AN update_aggregated_analytics (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/03_AC-update_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/03_AC update_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables (21040902)/02 AN NEW.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/02_AC populate_aggregated_accounting.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/02_AN-populate_aggregated_analytics.sql", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables (21040902)/02_AN-new populate_aggregated_analytics_unload.sql", "/Users/rsaporta/git/misc/rscripts/utils/unloadQry.r", "/Users/rsaporta/git/orch/src/DeNormalizing/zArchived/AggregatedTables 140715/02_AN-new populate_aggregated_analytics (140715).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/02_AN-new populate_aggregated_analytics (CHANGES).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/02_AC populate_aggregated_accounting (CHANGES).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zArchived/AggregatedTables 140715/02_AC populate_aggregated_accounting (140715).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zArchived/AggregatedTables 140715/01_AN create_aggregated_analytics (140715).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/01_AN create_aggregated_analytics (CHANGES).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/01_AC create_aggregated_accounting (CHANGES).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/zArchived/AggregatedTables 140715/01_AC create_aggregated_accounting (140715).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/02_AC populate_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/02_AC populate_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AGG_COMPARE/01_AC create_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/DeNormalizing/AggregatedTables 140902/01_AC create_aggregated_accounting (140902).sql", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_ZZ Join Cols and Export.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_b Ingest GL from Revenue Worksheet.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/RunIsAForecast.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/create_and_ingest_DT.MgmtReport_months_reported.r", "/Users/rsaporta/git/orch/src/GL Automation - forecasting.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/GL Automation - forecasting.r", "/Users/rsaporta/git/orch/ingest/MgmtReport/SC_splits/supplychain_split_percs.csv", "/Users/rsaporta/git/orch/src/MgmtReport/!! TODO", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_g DT.cleaned.agg.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_f Create DT.cleaned.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt1_c Ingest Revenue Summaries.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/showStoreAcc.r", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/calculateSplitPercentages.r", "/Users/rsaporta/git/orch/src/MgmtReport/March Revenue.r", "/Users/rsaporta/git/misc/SublimeTextStuff/symbolic links.txt", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/User/Enhanced-R/send.py", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/Enhanced-R/send.py", "/Users/rsaporta/Library/Application Support/Sublime Text 3/Packages/Enhanced-R/Enhanced-R.sublime-settings", "/Users/rsaporta/git/orch/src/MgmtReport/supportFns/addSuperBucket.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_b Create mgmtr_summary_tall from GL_Summaries.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_d Create DT.adjustments for rbinding.r", "/Users/rsaporta/git/orch/src/MgmtReport/GL_pt2_c Create DT.merged, Split & Expand.r" ], "find": { "height": 22.0 }, "find_in_files": { "height": 93.0, "where_history": [ "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Analytics", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/Accounting", "/Users/rsaporta/git/orch/src/DeNormalizing/", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/", "/Users/rsaporta/git/orch/src/DeNormalizing/", "/Users/rsaporta/git/orch/src/DeNormalizing/BI_tables/", "" ] }, "find_state": { "case_sensitive": false, "find_history": [ "schmea", "setdball", "Cu.", "Cu", "activity_month", "Cu.", "currency", "release_date", "Fa", "frontline", "fronlin", "fact_sales", "pr", "pri", "prio", "snowfla", "p1", "release_front_mid_or_cat", "Searching", "release_front_mid_or_cat", "releasedate >", "release_cat_or_front", "Ct.", "max", "proc", "max", "continent_group", "stream_vs_download", "Estimate of Gross Per Unit ", "gpuest", "transac_type_group", "store_name", "store_", "store_name_short", "store_name", "store_name_short", "store_name", "label_is_dthree", "download_", "AS download_", "download_", "download_activity_date", "month ", "accounting_", "p1.", "period_view", "period", "label_is_red", "label_is_supplychain", "label_", "label_is_supplychain", "## removed 20141017 ##", "##", "02b fa_errors_view.sql", "label_is_ioda", "label_is_ioda BOOLEAN", "label_is_IODA", "boolean", "label_is_dthree", "la.", "label_SC_group", "label_is_distributor", "label_is_dthree", "label_is_distributor", "owner", "boolean", "trackid", "dim_isrcid", "is_store_itunesUSA", "accounting_release_product_view", "royaltydollar", "tracktype", "fact_analytics", "nms.new.cols", "join.cols", ">", " \"greater_\",", "c(test1, test2)", "?", "water", "head", "DT.", "Vendor", "date", "DT.revshare", "revshareDownloadFiles", ";", "15", "Type codes", "TYPE", "skip", "dlFilesFromFTP", "DT.Spot_ASR_GPU", " DT.Spot_ASR_GPU", "Size.localFile", "tight.output", "drop.empty.sheets", "c(\"Grouping\", \"transac_type_abbr\")", "monthly", "DT.acc.daily", "cluster", "tbl.tmp", "stamp", "aggregated", "update", "tbl.tmp", "rename", "updateDeNormTable", "verbose.max.lines", "updateDeNormTable", "gsub", "last_file", "aggregated_", "findMaxDate", "browser", "Tbl.final", "tbl", "bucket", "tbl.old", "qRena", "reset", "fresh", "reset", "delete", "bucket", "tbl.tmp", "\n ", "whichColsCanBeInteger" ], "highlight": true, "in_selection": false, "preserve_case": false, "regex": false, "replace_history": [ "schema", "release_front_mid_or_cat_today", "release_front_mid_or_cat", "Searching", "releasedate >=", "store_name", "store_name_full", "store_name", "store_name_full", "", "-- ## removed 20141017 ##", "label_is_ioda VARCHAR(2) ENCODE lzo", "label_is_ioda BOOLEAN", "label_is_dthree", "release_product_view", "fact_analytics_error", "list", "nms.newCols", "nms.new.cols", "joinCols", " repl,", " \"greater_\",", "strings", "eight", "ten", "DT", "DT.revshare", "downloadFiles", "size.localFile", "Size.localFile", "kCols.Grp", "DT.acc.monthly", "DT.acc.daily", "", " THEN", " THEN", "schema", "schema.tmp", "-------", "03_AC", "'", "DT.merged2", "calculated", "MgmtReport_", "MgmtReport", "----------", "Revenue", "file.in", "kCols.smry_supbuk", "thisRunIsAForecast", "notForecasting", "!notForecasting", "DT.GL_forecasted", "notForecasting", "DT.cleaned.aggd2", "DT.MgmtReport", "DT.cleaned.aggd", "GL_net_forDSOM", "DT.manual", "DT.cleaned.aggd", "DT.cleaned.OSC", "OA_percof_DS_forDSOM", "label_sc_group %in% OSC_values", "label_sc_group %ni% c(\"RED\", \"Orchard\")", "calc.tol", "DT.cleaned", "tmp_DT.monthly_sums_by_grp", "tmp_DT.monthly_sums", "is.na(ancillaryline)", "!is.na(ancillaryline)", "lastDateClosed", "zUncatego", "zUncategorized", "zUncategorized Store", "unaggd_adjust_to_add", "tmp.perc_by_date_SC", "OA_percof_DSO_forDSOM", "OA_percof_DS_forDSOM", "kCols.date", "ASR_percof_DS_forDSO", "kCols.SC", "tmp_DT", "[, V1]", "OA_majority_group_forDS", "OA_majority_group_forS", "OA_ZeroEntirely_forS", "OA_ZeroMonth_forDS", "tmp.OA_gross_forDS", "tmp_", "OA_gross_forDSOM", ".imputed", "store_first_date_in_OA", "store_last_date_in_OA", "total_gross_by_DS", "DSOM_subtotalgross_oa", "DT.merged", "split_perc_asr", "DT.split_percs.unexpanded", "DT.split_percs", "DT.split_percs.unexpanded", "DSOM_subtotalgross_oa", "subtotalgross_oa", "DT.allMain", "cn", "kCols.SC_meta", "kCols.meta_SC", "kCols.SC_meta", "ret_DT", "newCol.nm", "nm.newCol", "DT", "month_is_zero_in_OA", "month_is_zero", "DT", "storeTotal_by_SC", "total_by_StoreSC", "AdSupported", "DT.split_percs", "kCols.main_nodate", "kCols.storeSC", "total_netsc_by_DSO", "perc_split_ofOA_byDSO", "perc_split_ofDSO_byDSO", "perc_split_ofDSO_bystatement", "perc_split_statement", "is.na(music_vs_video)", "is.na(label_sc_group)", "DT.mgmtr_summary_tall" ], "reverse": false, "show_context": false, "use_buffer2": true, "whole_word": false, "wrap": true }, "groups": [ { "selected": 0, "sheets": [ { "buffer": 0, "file": "/Users/rsaporta/git/orch/src/DeNormalizing/Additional Tables/track-artist from reportsAR.r", "semi_transient": false, "settings": { "buffer_size": 654, "regions": { }, "selection": [ [ 593, 593 ] ], "settings": { "BracketHighlighterBusy": false, "bh_regions": [ "bh_default", "bh_default_center", "bh_default_open", "bh_default_close", "bh_default_content", "bh_square", "bh_square_center", "bh_square_open", "bh_square_close", "bh_square_content", "bh_curly", "bh_curly_center", "bh_curly_open", "bh_curly_close", "bh_curly_content", "bh_single_quote", "bh_single_quote_center", "bh_single_quote_open", "bh_single_quote_close", "bh_single_quote_content", "bh_c_define", "bh_c_define_center", "bh_c_define_open", "bh_c_define_close", "bh_c_define_content", "bh_regex", "bh_regex_center", "bh_regex_open", "bh_regex_close", "bh_regex_content", "bh_double_quote", "bh_double_quote_center", "bh_double_quote_open", "bh_double_quote_close", "bh_double_quote_content", "bh_tag", "bh_tag_center", "bh_tag_open", "bh_tag_close", "bh_tag_content", "bh_angle", "bh_angle_center", "bh_angle_open", "bh_angle_close", "bh_angle_content", "bh_unmatched", "bh_unmatched_center", "bh_unmatched_open", "bh_unmatched_close", "bh_unmatched_content", "bh_round", "bh_round_center", "bh_round_open", "bh_round_close", "bh_round_content" ], "incomplete_sync": null, "r_box_status": false, "remote_loading": false, "synced": false, "syntax": "Packages/R-Box/syntax/R Extended.tmLanguage", "syntax_mgr_loaded": true }, "translation.x": 0.0, "translation.y": 0.0, "zoom_level": 1.0 }, "stack_index": 0, "type": "text" } ] } ], "incremental_find": { "height": 21.0 }, "input": { "height": 31.0 }, "layout": { "cells": [ [ 0, 0, 1, 1 ] ], "cols": [ 0.0, 1.0 ], "rows": [ 0.0, 1.0 ] }, "menu_visible": true, "output.find_results": { "height": 553.0 }, "output.sftp": { "height": 0.0 }, "pinned_build_system": "", "project": "DeNormalizing+AdditionalTables.sublime-project", "replace": { "height": 64.0 }, "save_all_on_build": true, "select_file": { "height": 0.0, "last_filter": "", "selected_items": [ [ "readspotifydatafiles", "supportFns/readSpotifyDataFiles.r" ], [ "push", "DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r" ], [ "ush", "DeNormalizing/zCleanTheseUp/AggregatedTables 140902/iTunes RED USA check.r" ], [ "jesusfordata_forecasting", "supportFns/jesusForData_Forecasting.r" ], [ "permeat", "supportFns/permeate.r" ], [ "dict.", "supportFns/dict.rev_summary_colnames.r" ], [ "dict", "supportFns/dict.GL_colnames.r" ], [ "manl_cr", "GL_pt3_a Create DT.manl_crop.r" ], [ "mkforecast", "supportFns/mkForecast.r" ], [ "ull", "supportFns/calculateSplitPercentages.r" ], [ "us", "supportFns/calculateSplitPercentages.r" ], [ "r", "03b DB_raw.r" ] ], "width": 0.0 }, "select_project": { "height": 500.0, "last_filter": "", "selected_items": [ ], "width": 380.0 }, "select_symbol": { "height": 107.0, "last_filter": "", "selected_items": [ ], "width": 392.0 }, "selected_group": 0, "settings": { }, "show_minimap": true, "show_open_files": true, "show_tabs": true, "side_bar_visible": true, "side_bar_width": 225.0, "status_bar_visible": true, "template_settings": { } }