P4_2_data_cleansing.yxmd

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2018.2">
  <Nodes>
    <Node ToolID="1">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
        <Position x="54" y="78" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Passwords />
          <File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="25">C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`</File>
          <FormatSpecificOptions>
            <FirstRowData>False</FirstRowData>
            <ImportLine>1</ImportLine>
          </FormatSpecificOptions>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>credit-data-training.xlsx
Table=`Sheet1$`</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="Credit-Application-Result" size="255" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="V_String" />
            <Field name="Account-Balance" size="255" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="V_String" />
            <Field name="Duration-of-Credit-Month" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
            <Field name="Payment-Status-of-Previous-Credit" size="255" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="V_String" />
            <Field name="Purpose" size="255" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="V_String" />
            <Field name="Credit-Amount" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
            <Field name="Value-Savings-Stocks" size="255" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="V_String" />
            <Field name="Length-of-current-employment" size="255" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="V_String" />
            <Field name="Instalment-per-cent" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
            <Field name="Guarantors" size="255" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="V_String" />
            <Field name="Duration-in-Current-address" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
            <Field name="Most-valuable-available-asset" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
            <Field name="Age-years" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
            <Field name="Concurrent-Credits" size="255" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="V_String" />
            <Field name="Type-of-apartment" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
            <Field name="No-of-Credits-at-this-Bank" size="255" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="V_String" />
            <Field name="Occupation" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
            <Field name="No-of-dependents" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
            <Field name="Telephone" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
            <Field name="Foreign-Worker" source="File: C:\chao\business data analysis\project 4 classification\credit-data-training.xlsx|||`Sheet1$`" type="Double" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
    </Node>
    <Node ToolID="2">
      <GuiSettings>
        <Position x="138" y="18" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Value name="do target">True</Value>
          <Value name="target">Credit-Application-Result</Value>
          <Value name="target level">Creditworthy</Value>
          <Value name="use fields">"Duration-of-Credit-Month","Credit-Amount","Instalment-per-cent","Duration-in-Current-address","Most-valuable-available-asset","Age-years","Type-of-apartment","No-of-dependents","Foreign-Worker"</Value>
          <Value name="Pearson">True</Value>
          <Value name="Spearman">False</Value>
          <Value name="Hoeffding">False</Value>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings Macro="Predictive Tools\Association_Analysis.yxmc" />
    </Node>
    <Node ToolID="3">
      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
        <Position x="246" y="6" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <TempFile>C:\Users\SL\AppData\Local\Temp\Engine_212888_ebf744fb37fc4adc8a2fb0f7257f83ae_\Engine_103632_e8cbd4fad30d443cb221982640816259_.yxdb</TempFile>
          <TempFileDataProfiling />
          <Layout>
            <ViewMode>Single</ViewMode>
            <ViewSize value="100" />
            <View1>
              <DefaultTab>Report</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>
    <Node ToolID="4">
      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
        <Position x="330" y="30" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <TempFile>C:\Users\SL\AppData\Local\Temp\Engine_212888_ebf744fb37fc4adc8a2fb0f7257f83ae_\Engine_103632_ebeb095963e447b4875cdce62ef9a208_.yxdb</TempFile>
          <TempFileDataProfiling />
          <Layout>
            <ViewMode>Single</ViewMode>
            <ViewSize value="100" />
            <View1>
              <DefaultTab>Report</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>
    <Node ToolID="5">
      <GuiSettings>
        <Position x="138" y="78" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Value name="Select Fields">Credit-Application-Result=True,Account-Balance=True,Duration-of-Credit-Month=True,Payment-Status-of-Previous-Credit=True,Purpose=True,Credit-Amount=True,Value-Savings-Stocks=True,Length-of-current-employment=True,Instalment-per-cent=True,Guarantors=True,Duration-in-Current-address=True,Most-valuable-available-asset=True,Age-years=True,Concurrent-Credits=True,Type-of-apartment=True,No-of-Credits-at-this-Bank=True,Occupation=True,No-of-dependents=True,Telephone=True,Foreign-Worker=True</Value>
          <Value name="Sample Data">False</Value>
          <Value name="Number">True</Value>
          <Value name="NNumber">5000</Value>
          <Value name="Percent">False</Value>
          <Value name="NPercent">10</Value>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
      </Properties>
      <EngineSettings Macro="Predictive Tools\Field_Summary_Report.yxmc" />
    </Node>
    <Node ToolID="6">
      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
        <Position x="246" y="78" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <TempFile>C:\Users\SL\AppData\Local\Temp\Engine_212888_ebf744fb37fc4adc8a2fb0f7257f83ae_\Engine_103632_69536857708749c8b94ed55c1a185bf4_.yxdb</TempFile>
          <TempFileDataProfiling />
          <Layout>
            <ViewMode>Single</ViewMode>
            <ViewSize value="100" />
            <View1>
              <DefaultTab>Report</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>
    <Node ToolID="7">
      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
        <Position x="246" y="126" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <TempFile>C:\Users\SL\AppData\Local\Temp\Engine_212888_ebf744fb37fc4adc8a2fb0f7257f83ae_\Engine_103632_14c5355808eb454bbf443f1062396ef5_.yxdb</TempFile>
          <TempFileDataProfiling />
          <Layout>
            <ViewMode>Single</ViewMode>
            <ViewSize value="100" />
            <View1>
              <DefaultTab>Report</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>
    <Node ToolID="8">
      <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
        <Position x="246" y="162" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <SummarizeFields>
            <SummarizeField field="Age-years" action="MedianNo0" rename="MedianNo0_Age-years" />
          </SummarizeFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
    </Node>
    <Node ToolID="9">
      <GuiSettings Plugin="AlteryxBasePluginsGui.AppendFields.AppendFields">
        <Position x="354" y="174" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <CartesianMode>Allow</CartesianMode>
          <SelectConfiguration>
            <Configuration outputConnection="Output">
              <OrderChanged value="False" />
              <CommaDecimal value="False" />
              <SelectFields>
                <SelectField field="*Unknown" selected="True" />
              </SelectFields>
            </Configuration>
          </SelectConfiguration>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxAppendFields" />
    </Node>
    <Node ToolID="10">
      <GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
        <Position x="138" y="162" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <OrderChanged value="False" />
          <CommaDecimal value="False" />
          <SelectFields>
            <SelectField field="Credit-Application-Result" selected="True" />
            <SelectField field="Account-Balance" selected="True" />
            <SelectField field="Duration-of-Credit-Month" selected="True" />
            <SelectField field="Payment-Status-of-Previous-Credit" selected="True" />
            <SelectField field="Purpose" selected="True" />
            <SelectField field="Credit-Amount" selected="True" />
            <SelectField field="Value-Savings-Stocks" selected="True" />
            <SelectField field="Length-of-current-employment" selected="True" />
            <SelectField field="Instalment-per-cent" selected="True" />
            <SelectField field="Most-valuable-available-asset" selected="True" />
            <SelectField field="Age-years" selected="True" />
            <SelectField field="Type-of-apartment" selected="True" />
            <SelectField field="No-of-Credits-at-this-Bank" selected="True" />
            <SelectField field="*Unknown" selected="False" />
          </SelectFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
    </Node>
    <Node ToolID="11">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="450" y="174" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="IF IsNull([Age-years]) THEN [MedianNo0_Age-years] ELSE [Age-years] ENDIF" field="Age-years" size="8" type="Double" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>Age-years = IF IsNull([Age-years]) THEN [MedianNo0_Age-years] ELSE [Age-years] E...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="12">
      <GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
        <Position x="558" y="174" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <OrderChanged value="False" />
          <CommaDecimal value="False" />
          <SelectFields>
            <SelectField field="Credit-Application-Result" selected="True" />
            <SelectField field="Account-Balance" selected="True" />
            <SelectField field="Duration-of-Credit-Month" selected="True" />
            <SelectField field="Payment-Status-of-Previous-Credit" selected="True" />
            <SelectField field="Purpose" selected="True" />
            <SelectField field="Credit-Amount" selected="True" />
            <SelectField field="Value-Savings-Stocks" selected="True" />
            <SelectField field="Length-of-current-employment" selected="True" />
            <SelectField field="Instalment-per-cent" selected="True" />
            <SelectField field="Most-valuable-available-asset" selected="True" />
            <SelectField field="Age-years" selected="True" />
            <SelectField field="Type-of-apartment" selected="True" />
            <SelectField field="No-of-Credits-at-this-Bank" selected="True" />
            <SelectField field="*Unknown" selected="False" />
          </SelectFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
    </Node>
    <Node ToolID="13">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
        <Position x="654" y="174" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <File FileFormat="19" MaxRecords="">C:\chao\business data analysis\project 4 classification\CLEAN DATA.yxdb</File>
          <Passwords />
          <FormatSpecificOptions>
            <NoSpatialIndex>False</NoSpatialIndex>
            <SaveSource>True</SaveSource>
          </FormatSpecificOptions>
          <MultiFile value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>CLEAN DATA.yxdb</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
    </Node>
    <Node ToolID="14">
      <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
        <Position x="558" y="234" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <SummarizeFields>
            <SummarizeField field="Age-years" action="Avg" rename="Avg_Age-years" />
          </SummarizeFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
    </Node>
    <Node ToolID="15">
      <GuiSettings>
        <Position x="198" y="234" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Value name="x var">Age-years</Value>
          <Value name="y var">Credit-Application-Result</Value>
          <Value name="y binary">True</Value>
          <Value name="y level">Creditworthy</Value>
          <Value name="reg line">True</Value>
          <Value name="smooth line">False</Value>
          <Value name="smooth span">50</Value>
          <Value name="spread">True</Value>
          <Value name="boxplots">True</Value>
          <Value name="jitter x">False</Value>
          <Value name="jitter y">False</Value>
          <Value name="log x">False</Value>
          <Value name="log y">False</Value>
          <Value name="groups">False</Value>
          <Value name="group var">Credit-Application-Result</Value>
          <Value name="group lines">False</Value>
          <Value name="default">True</Value>
          <Value name="topleft">False</Value>
          <Value name="topright">False</Value>
          <Value name="bottomleft">False</Value>
          <Value name="bottomright">False</Value>
          <Value name="x label" />
          <Value name="y label" />
          <Value name="pointsize">10</Value>
          <Value name="point size">1.0</Value>
          <Value name="axis text size">1.2</Value>
          <Value name="axis label size">1.3</Value>
          <Value name="title size">1.4</Value>
          <Value name="inches">True</Value>
          <Value name="in.w">5.50</Value>
          <Value name="in.h">5.50</Value>
          <Value name="centimeters">False</Value>
          <Value name="cm.w">13.00</Value>
          <Value name="cm.h">14.95</Value>
          <Value name="graph.resolution">1x</Value>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
      </Properties>
      <EngineSettings Macro="Predictive Tools\Scatterplot.yxmc" />
    </Node>
    <Node ToolID="16">
      <GuiSettings>
        <Position x="654" y="126" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Value name="x var">Age-years</Value>
          <Value name="y var">Credit-Application-Result</Value>
          <Value name="y binary">True</Value>
          <Value name="y level">Creditworthy</Value>
          <Value name="reg line">True</Value>
          <Value name="smooth line">False</Value>
          <Value name="smooth span">50</Value>
          <Value name="spread">True</Value>
          <Value name="boxplots">True</Value>
          <Value name="jitter x">False</Value>
          <Value name="jitter y">False</Value>
          <Value name="log x">False</Value>
          <Value name="log y">False</Value>
          <Value name="groups">False</Value>
          <Value name="group var">Credit-Application-Result</Value>
          <Value name="group lines">False</Value>
          <Value name="default">True</Value>
          <Value name="topleft">False</Value>
          <Value name="topright">False</Value>
          <Value name="bottomleft">False</Value>
          <Value name="bottomright">False</Value>
          <Value name="x label" />
          <Value name="y label" />
          <Value name="pointsize">10</Value>
          <Value name="point size">1.0</Value>
          <Value name="axis text size">1.2</Value>
          <Value name="axis label size">1.3</Value>
          <Value name="title size">1.4</Value>
          <Value name="inches">True</Value>
          <Value name="in.w">5.50</Value>
          <Value name="in.h">5.50</Value>
          <Value name="centimeters">False</Value>
          <Value name="cm.w">13.00</Value>
          <Value name="cm.h">14.95</Value>
          <Value name="graph.resolution">1x</Value>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
      </Properties>
      <EngineSettings Macro="Predictive Tools\Scatterplot.yxmc" />
    </Node>
    <Node ToolID="17">
      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
        <Position x="282" y="234" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <TempFile>C:\Users\SL\AppData\Local\Temp\Engine_212888_ebf744fb37fc4adc8a2fb0f7257f83ae_\Engine_103632_b058e639c96a4f51868c1da467192ae1_.yxdb</TempFile>
          <TempFileDataProfiling />
          <Layout>
            <ViewMode>Single</ViewMode>
            <ViewSize value="100" />
            <View1>
              <DefaultTab>Report</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>
    <Node ToolID="18">
      <GuiSettings Plugin="AlteryxBasePluginsGui.BrowseV2.BrowseV2">
        <Position x="750" y="126" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <TempFile>C:\Users\SL\AppData\Local\Temp\Engine_212888_ebf744fb37fc4adc8a2fb0f7257f83ae_\Engine_103632_219a345e87eb430e9d4c437a4121debf_.yxdb</TempFile>
          <TempFileDataProfiling />
          <Layout>
            <ViewMode>Single</ViewMode>
            <ViewSize value="100" />
            <View1>
              <DefaultTab>Report</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="1" Connection="Output" />
      <Destination ToolID="2" Connection="Data Input" />
    </Connection>
    <Connection>
      <Origin ToolID="1" Connection="Output" />
      <Destination ToolID="5" Connection="Field Input" />
    </Connection>
    <Connection>
      <Origin ToolID="1" Connection="Output" />
      <Destination ToolID="10" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="2" Connection="Output" />
      <Destination ToolID="3" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="2" Connection="Correlation Matrix" />
      <Destination ToolID="4" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="5" Connection="Reports" />
      <Destination ToolID="6" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="5" Connection="Interactive" />
      <Destination ToolID="7" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="8" Connection="Output" />
      <Destination ToolID="9" Connection="Targets" />
    </Connection>
    <Connection>
      <Origin ToolID="10" Connection="Output" />
      <Destination ToolID="9" Connection="Source" />
    </Connection>
    <Connection>
      <Origin ToolID="9" Connection="Output" />
      <Destination ToolID="11" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="10" Connection="Output" />
      <Destination ToolID="8" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="10" Connection="Output" />
      <Destination ToolID="15" Connection="Data Input" />
    </Connection>
    <Connection>
      <Origin ToolID="11" Connection="Output" />
      <Destination ToolID="12" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="11" Connection="Output" />
      <Destination ToolID="14" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="12" Connection="Output" />
      <Destination ToolID="13" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="12" Connection="Output" />
      <Destination ToolID="16" Connection="Data Input" />
    </Connection>
    <Connection>
      <Origin ToolID="15" Connection="Scater Output" />
      <Destination ToolID="17" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="16" Connection="Scater Output" />
      <Destination ToolID="18" 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>2 data cleaning</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>