BI-Scripts/whvfrp.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
version "1";

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

object 'TASK' "WHVFRP" {
   inputs     = {
   		"base input",
                },
   processes  = {
		"calcs",
                },
   output     = "out"
};


object 'INPT'   "base input" {
   input_type   = "Filein",
   filename     = "../temp/whvfrp.txt",
   file_type    = "column_headers",
};

object 'PROC'   "calcs" {
   process_type = "calc",
   input        = "base input",
   calcs        = {
    { column    = "Vendor YTD",
    calc_str    = "if(and(substr(VFRP,1,4)=\"9999\",substr(VFRP,6,2)<=Fiscal Month Count),1,0)" },
    { column    = "Vendor LYTD",
    calc_str    = "if(and(substr(VFRP,1,4)=\"9998\",substr(VFRP,6,2)<=Fiscal Month Count),1,0)" },
    { column    = "Vendor LY",
    calc_str    = "if(substr(VFRP,1,4)=\"9998\",1,0)" },
   },
};

object 'OUTP'   "out" {
   output_type  = "fileout",
   input        = "calcs",
   file_type    = "column_headers",
   filename     = "../temp/whvendortime.txt",
   columns      = {
	"City Abbrev",
	"Year",
	"Month",
	"Vendor Fiscal Month",
	"VFRP",
	"Vendor YTD",
	"Vendor LYTD",
	"Vendor LY",
	"Fiscal Month Count",
	"Mo1",
	"Mo2",
	"Mo3",
	"Mo4",
	"Mo5",
	"Mo6",
	"Mo7",
	"Mo8",
	"Mo9",
	"Mo10",
	"Mo11",
	"Mo12",
   },
};