-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathQuarters.yxmd
122 lines (122 loc) · 4.18 KB
/
Quarters.yxmd
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
<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.2">
<Nodes>
<Node ToolID="1">
<GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
<Position x="126" y="126" />
</GuiSettings>
<Properties>
<Configuration>
<NumRows value="3" />
<Fields>
<Field name="Date" />
</Fields>
<Data>
<r>
<c>12-11-2017</c>
</r>
<r>
<c>08-07-2019</c>
</r>
<r>
<c>01-01-2018</c>
</r>
</Data>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
</Node>
<Node ToolID="2">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="234" y="126" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression="DateTimeParse([Date],"%m-%d-%Y")" field="Parsed" size="10" type="Date" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText><![CDATA[Parsed = DateTimeParse([Date],"%m-%d-%Y")
]]></DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
<Node ToolID="3">
<GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
<Position x="342" y="126" />
</GuiSettings>
<Properties>
<Configuration>
<FormulaFields>
<FormulaField expression="Left([Parsed],5) +
PadLeft(ToString(Ceil(DateTimeMonth([Parsed])/3)*3-2),2, '0')
+ '-01'
" field="StartOfQuarter" size="10" type="Date" />
<FormulaField expression="DateTimeTrim(Left([Parsed],5) +
PadLeft(ToString(Ceil(DateTimeMonth([Parsed])/3)*3),2, '0')
+ '-01', "lastofmonth")
" field="EndOfQuarter" size="10" type="Date" />
</FormulaFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>StartOfQuarter = Left([Parsed],5) +
PadLeft(ToString(Ceil(DateTimeMonth([Parsed]...</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
</Node>
</Nodes>
<Connections>
<Connection>
<Origin ToolID="1" Connection="Output" />
<Destination ToolID="2" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="2" Connection="Output" />
<Destination ToolID="3" Connection="Input" />
</Connection>
</Connections>
<Properties>
<Memory default="True" />
<GlobalRecordLimit value="0" />
<TempFiles default="True" />
<Annotation on="True" includeToolName="False" />
<ConvErrorLimit value="10" />
<ConvErrorLimit_Stop value="False" />
<CancelOnError value="False" />
<DisableBrowse value="False" />
<EnablePerformanceProfiling value="False" />
<DisableAllOutput value="False" />
<ShowAllMacroMessages value="False" />
<ShowConnectionStatusIsOn value="True" />
<ShowConnectionStatusOnlyWhenRunning value="False" />
<ZoomLevel value="0" />
<LayoutType>Horizontal</LayoutType>
<MetaInfo>
<NameIsFileName value="True" />
<Name>Quarters</Name>
<Description />
<RootToolName />
<ToolVersion />
<ToolInDb value="False" />
<CategoryName />
<SearchTags />
<Author />
<Company />
<Copyright />
<DescriptionLink actual="" displayed="" />
<Example>
<Description />
<File />
</Example>
</MetaInfo>
<Events>
<Enabled value="True" />
</Events>
</Properties>
</AlteryxDocument>