14. Filter.yxmd

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2023.2" RunE2="T">
  <Nodes>
    <Node ToolID="1">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
        <Position x="102" y="138" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Passwords />
          <File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="25">C:\Users\Aakarsh Roy\Downloads\Unclean Covid19-31Oct2020.xlsx|||`Covid19-31Oct2020$`</File>
          <FormatSpecificOptions>
            <FirstRowData>False</FirstRowData>
            <ImportLine>1</ImportLine>
          </FormatSpecificOptions>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>Unclean Covid19-31Oct2020.xlsx
Query=`Covid19-31Oct2020$`</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="State" size="255" source="File: C:\Users\Aakarsh Roy\Downloads\Unclean Covid19-31Oct2020.xlsx|||`Covid19-31Oct2020$`" type="V_String" />
            <Field name="Confirmed" source="File: C:\Users\Aakarsh Roy\Downloads\Unclean Covid19-31Oct2020.xlsx|||`Covid19-31Oct2020$`" type="Double" />
            <Field name="Active" source="File: C:\Users\Aakarsh Roy\Downloads\Unclean Covid19-31Oct2020.xlsx|||`Covid19-31Oct2020$`" type="Double" />
            <Field name="Recovered" source="File: C:\Users\Aakarsh Roy\Downloads\Unclean Covid19-31Oct2020.xlsx|||`Covid19-31Oct2020$`" type="Double" />
            <Field name="Deceased" source="File: C:\Users\Aakarsh Roy\Downloads\Unclean Covid19-31Oct2020.xlsx|||`Covid19-31Oct2020$`" type="Double" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
    </Node>
    <Node ToolID="2">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="222" y="138" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Mode>Simple</Mode>
          <Simple>
            <Operator>&lt;</Operator>
            <Field>Active</Field>
            <Operands>
              <IgnoreTimeInDateTime>True</IgnoreTimeInDateTime>
              <DateType>fixed</DateType>
              <PeriodDate>2024-02-21 12:22:47</PeriodDate>
              <PeriodType>
              </PeriodType>
              <PeriodCount>0</PeriodCount>
              <Operand>1000</Operand>
              <StartDate>2024-02-21 12:22:47</StartDate>
              <EndDate>2024-02-21 12:22:47</EndDate>
            </Operands>
          </Simple>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>[Active] &lt; 1000</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
    <Node ToolID="3">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="234" y="234" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Expression>[Active]&lt;10000 AND [Active]&gt;5000</Expression>
          <Mode>Custom</Mode>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>[Active]&lt;10000 AND [Active]&gt;5000</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
    <Node ToolID="4">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="306" y="18" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Expression>[Active]&gt;500 AND [Confirmed]&gt;10000 AND [Recovered]&lt;25000</Expression>
          <Mode>Custom</Mode>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>[Active]&gt;500 AND [Confirmed]&gt;10000 AND [Recovered]&lt;25000</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
  </Nodes>
  <Connections>
    <Connection>
      <Origin ToolID="1" Connection="Output" />
      <Destination ToolID="2" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="1" Connection="Output" />
      <Destination ToolID="3" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="1" Connection="Output" />
      <Destination ToolID="4" 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" />
    <RunWithE2 value="True" />
    <PredictiveToolsCodePage value="1252" />
    <DisableAllOutput value="False" />
    <ShowAllMacroMessages value="False" />
    <ShowConnectionStatusIsOn value="True" />
    <ShowConnectionStatusOnlyWhenRunning value="True" />
    <ZoomLevel value="0" />
    <LayoutType>Horizontal</LayoutType>
    <MetaInfo>
      <NameIsFileName value="True" />
      <Name>14. Filter</Name>
      <Description />
      <RootToolName />
      <ToolVersion />
      <ToolInDb value="False" />
      <CategoryName />
      <SearchTags />
      <Author />
      <Company />
      <Copyright />
      <DescriptionLink actual="" displayed="" />
      <Example>
        <Description />
        <File />
      </Example>
      <WorkflowId value="aa822c07-ae21-4d11-a351-a8c8824f6088" />
      <Telemetry>
        <PreviousWorkflowId value="dc367f5d-cab9-4dcb-b14d-8b9a236ec376" />
        <OriginWorkflowId value="dc367f5d-cab9-4dcb-b14d-8b9a236ec376" />
      </Telemetry>
      <PlatformWorkflowId value="" />
    </MetaInfo>
    <Events>
      <Enabled value="True" />
    </Events>
  </Properties>
</AlteryxDocument>