BI-Scripts/exwhitem.int at master · OMR5221/BI-Scripts · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
version "1";

object 'TSKL' "Main" {
   {
	 "Detail",
   }
};

object 'TASK' "Detail" {
   inputs     = {
   		"item",
		"warehouse",
		"whvendortime",
		"state list",
                },
   processes  = {
		"join",
		"Do Calcs",
		"squash whvendortime",
		"Join whvendortime",
		"state list calcs",
		"join state list",
		"filter on state list",
                },
   output     = "Split"
};


object 'INPT'   "item" {
   input_type   = "Filein",
   filename     = `../data/gowimpdd.csv`,
   dictfile     = "../programs/gowimp.dic"
};

object 'INPT'   "warehouse" {
   input_type   = "Filein",
   filename     = `../data/gogwmpdd.csv`,
   dictfile     = "../programs/gogwmp.dic"
};

object 'INPT'   "whvendortime" {
   input_type   = "Filein",
   filename     = "../temp/whvendortime.txt",
   file_type    = "column_headers",
   keep_columns = {"City Abbrev","Vendor Fiscal Month","Fiscal Month Count"},
};

object 'INPT'   "state list" {
   input_type   = "Filein",
   filename     = "../execmdls/exbuildorder.txt",
   file_type    = "column_headers",
   aliases      = {
	"State Name=Buildorder Name"
   },
};

object 'PROC'   "join" {
   process_type = "lookup",
   inputs       = {"item","warehouse"},
   joins        = {"Warehouse Number","Warehouse Number" },
};

object 'PROC'   "squash whvendortime" {
   process_type = "squash",
   input        = "whvendortime",
   adjacent     = "false",
   dimensions   = {
	"City Abbrev",
	"Vendor Fiscal Month",
   },
   info         = {
	"Fiscal Month Count",
   },
};

object 'PROC'   "join whvendortime" {
   process_type = "lookup",
   inputs       = {"join","squash whvendortime"},
   multijoins   = {
	{"City Abbrev","City Abbrev" },
	{"Vendor Fiscal Month","Vendor Fiscal Month" },
   },
};

object 'PROC'   "state list calcs" {
   process_type = "calc",
   input        = "state list",
   calcs        = {
    {  column   = "State Filter",
       calc_str = "\"Keep\""  },
		  },
};

object 'PROC'   "join state list" {
   process_type = "lookup",
   inputs       = {"join whvendortime","state list calcs"},
   joins        = {"Warehouse State","State" },
};

object 'PROC'   "filter on state list" {
   process_type = "filter",
   input        = "join state list",
   action       = "keep",
   filters      = {
      { column  = "State Filter",
        values  = {"Keep"}},
   },
};

object 'PROC'   "Do Calcs" {
   process_type = "calc",
   input        = "filter on state list",
   calcs        = {
    {  column   = "Vendor RC# Base",
       calc_str = "Vendor Report Code Number"  },
    {  column   = "Model",
       calc_str = `concat(\"../temp/\",City Abbrev,\"-corpitem=\",Warehouse State,\".txt\")`  },
		  },
};

object 'OUTP'   "Split" {
   output_type  = "split",
   input        = "Do calcs",
   dictfile1    = "../temp/corpitem-wh.dic",
   filename_column     = "Model",
   reportfile   = "../temp/whitem.rep",
   reportfile_type = "column_headers",
   remove_columns = {"Vendor Report Code Number","Model"},
};