Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
175 lines (175 sloc) 8.01 KB
<?xml version="1.0"?>
<AlteryxDocument yxmdVer="11.3">
<Nodes>
<Node ToolID="2">
<GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
<Position x="54" y="54" />
</GuiSettings>
<Properties>
<Configuration>
<Passwords />
<File OutputFileName="" FileFormat="19" SearchSubDirs="False" RecordLimit="">.\2016PPData.yxdb</File>
<FormatSpecificOptions />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>2016PPData.yxdb</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="Output">
<RecordInfo>
<Field description="A reference number which is generated automatically recording each published sale. The number is unique and will change each time a sale is recorded." name="Transaction unique identifier" size="38" source="File: D:\Downloads\pp-complete.csv" type="String" />
<Field description=" Sale price stated on the transfer deed." name="Price" source="File: D:\Downloads\pp-complete.csv" type="Int32" />
<Field description="Date when the sale was completed, as stated on the transfer deed." name="Date of Transfer" source="File: D:\Downloads\pp-complete.csv" type="Date" />
<Field description="This is the postcode used at the time of the original transaction." name="Postcode" size="8" source="File: D:\Downloads\pp-complete.csv" type="String" />
<Field description="RegEx: Parsed from Postcode" name="PostCodeArea" size="2" source="RegEx: Parsed from Postcode" type="String" />
<Field description="RegEx: Parsed from Postcode" name="PostCodeDistrict" size="2" source="RegEx: Parsed from Postcode" type="String" />
<Field description="RegEx: Parsed from Postcode" name="PostCodeSector" source="RegEx: Parsed from Postcode" type="Byte" />
<Field description="RegEx: Parsed from Postcode" name="PostCodeUnit" size="2" source="RegEx: Parsed from Postcode" type="String" />
<Field description="D = Detached, S = Semi-Detached, T = Terraced, F = Flats/Maisonettes, O = Other" name="Property Type" size="1" source="File: D:\Downloads\pp-complete.csv" type="String" />
<Field description="Is it a Newly Built Property" name="NewBuild" source="Formula: [_CurrentField_]='Y'" type="Bool" />
<Field description="F = Freehold, L= Leasehold" name="Duration" size="1" source="File: D:\Downloads\pp-complete.csv" type="String" />
<Field description="Primary Addressable Object Name. Typically the house number or name" name="PAON" size="64" source="File: D:\Downloads\pp-complete.csv" type="V_String" />
<Field description="Secondary Addressable Object Name." name="SAON" size="64" source="File: D:\Downloads\pp-complete.csv" type="V_String" />
<Field name="Street" size="64" source="File: D:\Downloads\pp-complete.csv" type="V_String" />
<Field name="Locality" size="64" source="File: D:\Downloads\pp-complete.csv" type="V_String" />
<Field name="Town/City" size="32" source="File: D:\Downloads\pp-complete.csv" type="V_String" />
<Field name="District" size="32" source="File: D:\Downloads\pp-complete.csv" type="V_String" />
<Field name="County" size="32" source="File: D:\Downloads\pp-complete.csv" type="V_String" />
<Field name="PPDCategory Type" size="1" source="File: D:\Downloads\pp-complete.csv" type="String" />
</RecordInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
</Node>
<Node ToolID="3">
<GuiSettings Plugin="AlteryxBasePluginsGui.Sort.Sort">
<Position x="186" y="54" />
</GuiSettings>
<Properties>
<Configuration>
<SortInfo locale="0">
<Field field="County" order="Ascending" />
<Field field="PostCodeArea" order="Ascending" />
<Field field="Price" order="Descending" />
</SortInfo>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>County - Ascending
PostCodeArea - Ascending
Price - Descending</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSort" />
</Node>
<Node ToolID="4">
<GuiSettings Plugin="AlteryxBasePluginsGui.MultiRowFormula.MultiRowFormula">
<Position x="306" y="54" />
</GuiSettings>
<Properties>
<Configuration>
<UpdateField value="False" />
<UpdateField_Name>Transaction unique identifier</UpdateField_Name>
<CreateField_Name>RecordID</CreateField_Name>
<CreateField_Type>Int32</CreateField_Type>
<CreateField_Size>4</CreateField_Size>
<OtherRows>Empty</OtherRows>
<NumRows value="1" />
<Expression>[Row-1:RecordID]+1</Expression>
<GroupByFields>
<Field field="PostCodeArea" />
<Field field="County" />
</GroupByFields>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>[Row-1:RecordID]+1</DefaultAnnotationText>
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxMultiRowFormula" />
</Node>
<Node ToolID="5">
<GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
<Position x="414" y="54" />
</GuiSettings>
<Properties>
<Configuration>
<TempFile>C:\ProgramData\Alteryx\Engine\Engine_17324_03677a94501a4d0ebe26b9de07aa2875_\Engine_14844_f5851dc65158448ab2d62a92ef6783dc_.yxdb</TempFile>
<TempFileDataProfiling />
<Layout>
<ViewMode>Single</ViewMode>
<ViewSize value="100" />
<View1>
<DefaultTab>Profile</DefaultTab>
<Hints>
<Table />
</Hints>
</View1>
<View2 />
</Layout>
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxBrowseV2" />
</Node>
</Nodes>
<Connections>
<Connection>
<Origin ToolID="2" Connection="Output" />
<Destination ToolID="3" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="3" Connection="Output" />
<Destination ToolID="4" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="4" Connection="Output" />
<Destination ToolID="5" 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="True" />
<ZoomLevel value="0" />
<LayoutType>Horizontal</LayoutType>
<MetaInfo>
<NameIsFileName value="True" />
<Name>Example Workflow</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>