BI-Scripts/whlookup.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
// Script generated by DI Visual Integrator

version "1";
object 'PARM' "Parms" {
	parms = {
		{
			name = "LETTER"
		}
	}
};

object 'TSKL' "Main" {
	contents = {
		`Warehouse Lookup`
	}
};

object 'TASK' "Warehouse lookup" {
	inputs    = {
		`warehouse`
	},
	processes = {
		`calcs`
	},
	output    = `output`
};

object 'INPT' "warehouse" {
	//+ coordinatex = `8`,
	//+ coordinatey = `8`,
	input_type  = `Filein`,
	starnames   = { `../data/$(LETTER)gogwmpdd.csv` },
	dictfile    = `../programs/gogwmp.dic`
};

object 'PROC' "calcs" {
	//+ coordinatex = `83`,
	//+ coordinatey = `8`,
	process_type = `calc`,
	input        = `warehouse`,
	calcs        = {
		{
			name  = `Warehouse`,
			value = `Warehouse City`
		},
		{
			name  = `Warehouse With Number`,
			value = `concat(Warehouse City," -- ",Warehouse Number)`
		}
	}
};

object 'OUTP' "output" {
	//+ coordinatex = `158`,
	//+ coordinatey = `8`,
	output_type = `fileout`,
	input       = `calcs`,
	file_type   = `column_headers`,
	filename    = `../models/$(LETTER)whlookup.txt`,
	columns     = { `Warehouse`, `Download Date`, `Download Time` }
};

//+audits = {
//+`<2014-06-06>, <Bill Lee>: Modified script`,
//+}