community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

2 Loops, Single Batch Macro

nathan853
7 - Meteor
‎10-23-2019 06:00 AM

Hi everyone. 

 

I´m fairly new to the forum, and it has been helping me heaps with Alteryx.

 

I managed to create and successfully run a Batch Marco for a data set I have. But I can´t get it to work with two control parameters looping 2 different inputs of controls, one for each control parameter. The Workflow runs without errors and it outputs part of the expected output, but not exactly. 

 

I cannot share details about the data i´m working with, but I´v attached my Batch Macro and my Workflow with some commentary.

 

Long story short, the sheet is basically a data log for around 80 operators. It registers, with a unique ID, every operators actions with a time stamp, for each work shift for each day.

Example: ID 50 - John Snow - Night Shift - Dec 20th 2018 - Some problem appeared at 03:19:15 - Started doing something at 03:23:59 - Finished doing it at 03:25:55

 

With the Batch Macro, I can calculate how many actions each operator did for each day and also the average time each operator took from the time a problem appeared to the time it started doing something, and the average time the operator took to finish doing what he started. So far so good.

But I also have to verify how many actions were log correctly, since the operator can start 2 or more different actions at the same time, messing with the real average time to solution. So I have a multi-row tool to check if the starting time of the next action is greater than the finish time of the previous action. Than I recalculate the averages for this now 'corrected' data log and join them all at the end.

The expected sheet is something like this:

Dec 20th 2018 - Night Shift - John Snow - did 100 actions - avg response time 200 sec - avg workaround time 800 sec - 89 actions were time registered correctly - corrected avg response time 100 sec - corrected avg workaround time 400 sec

 

If I were to run all this individually, id take me days if not weeks to change the filters for every operator, for every day, for every work shift.

 

My Batch Macro outputs all operator details with the averages, but only one operator for each day will have the corrected averages filled in.

It´s clearly something I´m missing in my workflow, but I can´t seem to figure it out.

Any help would be greatly appreciated! 

 

Thanks!

 

ps.: I can´t upload any screenshots due to company policy. I can however, get the code for the macro and workflow attached. I´ll modify them and post them shortly.

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

12 REPLIES 12
nathan853
7 - Meteor
‎10-23-2019 07:07 AM

Part 7:

 

<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText>[RecordID] = 1</DefaultAnnotationText>
<Left value="False" />
</Annotation>
<MetaInfo connection="True">
<RecordInfo>
<Field name="RecordID" source="RecordID: Starting Value=1" type="Int32" />
<Field name="Operador" size="255" source="Formula: LowerCase([Operador])" type="V_String" />
<Field name="Right_RecordID" source="RecordID: Starting Value=1" type="Int32" />
<Field name="Dia Efetivo Turno" size="255" source="Summarize: GroupBy - Dia Efetivo Turno" type="V_String" />
<Field name="Gravidade" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="ID" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Data Recebimento" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Hora Recebimento" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Tempo de Resposta" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Data Finalizou Evento" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Hora Finalizou Evento" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Ponto" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Tipo Ocorrencia" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Right_Operador" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Status" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Dia Semana" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Feriado" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Periodo" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="tresp s" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Right_Dia Efetivo Turno" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="type" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="T_Tratativa" source="File: C:\file.xlsm" type="Double" />
<Field name="T_Tratativa_Min" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="cod_ocorrencia" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="sinal" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="descricao" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="tp_evento" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="desc_particao" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="desc_zona" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="origem" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="cod_sinal" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="AGCOD" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="UF" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="MUNICIPIO" size="255" source="File: C:\file.xlsm" type="V_WString" />
</RecordInfo>
<SortInfo>
<Field field="Operador" order="" />
</SortInfo>
</MetaInfo>
<MetaInfo connection="False">
<RecordInfo>
<Field name="RecordID" source="RecordID: Starting Value=1" type="Int32" />
<Field name="Operador" size="255" source="Formula: LowerCase([Operador])" type="V_String" />
<Field name="Right_RecordID" source="RecordID: Starting Value=1" type="Int32" />
<Field name="Dia Efetivo Turno" size="255" source="Summarize: GroupBy - Dia Efetivo Turno" type="V_String" />
<Field name="Gravidade" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="ID" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Data Recebimento" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Hora Recebimento" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Tempo de Resposta" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Data Finalizou Evento" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Hora Finalizou Evento" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Ponto" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Tipo Ocorrencia" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Right_Operador" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Status" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Dia Semana" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Feriado" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Periodo" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="tresp s" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="Right_Dia Efetivo Turno" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="type" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="T_Tratativa" source="File: C:\file.xlsm" type="Double" />
<Field name="T_Tratativa_Min" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="cod_ocorrencia" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="sinal" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="descricao" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="tp_evento" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="desc_particao" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="desc_zona" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="origem" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="cod_sinal" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="AGCOD" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="UF" size="255" source="File: C:\file.xlsm" type="V_String" />
<Field name="MUNICIPIO" size="255" source="File: C:\file.xlsm" type="V_WString" />
</RecordInfo>
<SortInfo>
<Field field="Operador" order="" />
</SortInfo>
</MetaInfo>
</Properties>
<EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
</Node>
<Node ToolID="42">
<GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
<Position x="677" y="78" width="251" height="142" />
</GuiSettings>
<Properties>
<Configuration>
<Caption>Batch Macro - Controls Group</Caption>
<Style TextColor="#ffff00" FillColor="#ad48ff" BorderColor="#c4c400" Transparency="25" Margin="25" />
<Disabled value="False" />
<Folded value="False" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<ChildNodes>
<Node ToolID="40">
<GuiSettings Plugin="AlteryxGuiToolkit.Questions.ControlParam.ControlParam">
<Position x="702" y="124" width="59" height="59" />
</GuiSettings>
<Properties>
<Configuration />
<Annotation DisplayMode="0">
<Name>CP 1</Name>
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="41">
<GuiSettings Plugin="AlteryxGuiToolkit.Action.Action">
<Position x="774" y="136" width="59" height="59" />
</GuiSettings>
<Properties>
<Configuration />
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
</ChildNodes>
</Node>
<Node ToolID="83">
<GuiSettings Plugin="AlteryxGuiToolkit.ToolContainer.ToolContainer">
<Position x="1350" y="388" width="287" height="142" />
</GuiSettings>
<Properties>
<Configuration>
<Caption>Batch Macro - Controls Group</Caption>
<Style TextColor="#ffff00" FillColor="#ad48ff" BorderColor="#c4c400" Transparency="25" Margin="25" />
<Disabled value="False" />
<Folded value="False" />
</Configuration>
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
<ChildNodes>
<Node ToolID="81">
<GuiSettings Plugin="AlteryxGuiToolkit.Questions.ControlParam.ControlParam">
<Position x="1375" y="434" width="59" height="59" />
</GuiSettings>
<Properties>
<Configuration />
<Annotation DisplayMode="0">
<Name>CP 2</Name>
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
<Node ToolID="82">
<GuiSettings Plugin="AlteryxGuiToolkit.Action.Action">
<Position x="1459" y="446" width="59" height="59" />
</GuiSettings>
<Properties>
<Configuration />
<Annotation DisplayMode="0">
<Name />
<DefaultAnnotationText />
<Left value="False" />
</Annotation>
</Properties>
</Node>
</ChildNodes>
</Node>
</Nodes>
<Connections>
<Connection>
<Origin ToolID="11" Connection="Output" />
<Destination ToolID="38" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="20" Connection="Output" />
<Destination ToolID="23" Connection="Input" />
</Connection>
<Connection name="#2">
<Origin ToolID="41" Connection="Action" />
<Destination ToolID="23" Connection="Action" />
</Connection>
<Connection>
<Origin ToolID="21" Connection="Output" />
<Destination ToolID="20" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="22" Connection="Join" />
<Destination ToolID="29" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="22" Connection="Join" />
<Destination ToolID="25" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="22" Connection="Join" />
<Destination ToolID="24" Connection="Input" />
</Connection>
<Connection name="#4">
<Origin ToolID="22" Connection="Join" />
<Destination ToolID="30" Connection="Input" />
</Connection>
<Connection name="#1">
<Origin ToolID="27" Connection="Output" />
<Destination ToolID="30" Connection="Input" />
</Connection>
<Connection name="#2">
<Origin ToolID="28" Connection="Output" />
<Destination ToolID="30" Connection="Input" />
</Connection>
<Connection name="#3">
<Origin ToolID="32" Connection="Output" />
<Destination ToolID="30" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="22" Connection="Join" />
<Destination ToolID="60" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="22" Connection="Join" />
<Destination ToolID="62" Connection="Right" />
</Connection>
<Connection>
<Origin ToolID="61" Connection="Output" />
<Destination ToolID="62" Connection="Left" />
</Connection>
<Connection>
<Origin ToolID="23" Connection="True" />
<Destination ToolID="22" Connection="Left" />
</Connection>
<Connection>
<Origin ToolID="39" Connection="True" />
<Destination ToolID="22" Connection="Right" />
</Connection>
<Connection>
<Origin ToolID="25" Connection="Output" />
<Destination ToolID="27" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="27" Connection="Output" />
<Destination ToolID="26" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="29" Connection="Output" />
<Destination ToolID="28" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="29" Connection="Output" />
<Destination ToolID="32" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="30" Connection="Output" />
<Destination ToolID="43" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="30" Connection="Output" />
<Destination ToolID="44" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="33" Connection="Output" />
<Destination ToolID="34" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="34" Connection="Output" />
<Destination ToolID="31" Connection="Input" />
</Connection>
<Connection name="#1">
<Origin ToolID="34" Connection="Output" />
<Destination ToolID="77" Connection="Input" />
</Connection>
<Connection name="#2">
<Origin ToolID="75" Connection="Unique" />
<Destination ToolID="77" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="38" Connection="True" />
<Destination ToolID="39" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="39" Connection="True" />
<Destination ToolID="21" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="44" Connection="Unique" />
<Destination ToolID="33" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="48" Connection="Output" />
<Destination ToolID="49" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="48" Connection="Output" />
<Destination ToolID="50" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="50" Connection="True" />
<Destination ToolID="53" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="50" Connection="False" />
<Destination ToolID="56" Connection="Input8" />
</Connection>
<Connection>
<Origin ToolID="50" Connection="True" />
<Destination ToolID="58" Connection="Input8" />
</Connection>
<Connection name="#1">
<Origin ToolID="51" Connection="Output" />
<Destination ToolID="54" Connection="Input" />
</Connection>
<Connection name="#2">
<Origin ToolID="52" Connection="Output" />
<Destination ToolID="54" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="53" Connection="Output" />
<Destination ToolID="51" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="53" Connection="Output" />
<Destination ToolID="52" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="54" Connection="Output" />
<Destination ToolID="69" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="54" Connection="Output" />
<Destination ToolID="70" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="56" Connection="Output9" />
<Destination ToolID="57" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="58" Connection="Output9" />
<Destination ToolID="59" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="58" Connection="Output9" />
<Destination ToolID="72" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="60" Connection="Output" />
<Destination ToolID="67" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="60" Connection="Output" />
<Destination ToolID="65" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="61" Connection="Output" />
<Destination ToolID="63" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="62" Connection="Join" />
<Destination ToolID="68" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="62" Connection="Join" />
<Destination ToolID="84" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="66" Connection="Output" />
<Destination ToolID="61" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="67" Connection="Output" />
<Destination ToolID="66" Connection="Input" />
</Connection>
<Connection>
<Origin ToolID="69" Connection="Output" />
<Destination ToolID="71" Connection="Input" />
</Connection>
<Connection name="#1">
<Origin ToolID="71" Connection="True" />
<Destination ToolID="73" Connection="Input" />
</Connection>

Reply
0 Likes
nathan853
7 - Meteor
‎10-23-2019 07:10 AM

Final:

 

 <Connection name="#3">
      <Origin ToolID="72" Connection="Output" />
      <Destination ToolID="73" Connection="Input" />
    </Connection>
    <Connection name="#2">
      <Origin ToolID="85" Connection="True" />
      <Destination ToolID="73" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="73" Connection="Output" />
      <Destination ToolID="75" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="73" Connection="Output" />
      <Destination ToolID="74" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="75" Connection="Unique" />
      <Destination ToolID="76" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="77" Connection="Output" />
      <Destination ToolID="78" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="78" Connection="Output" />
      <Destination ToolID="79" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="78" Connection="Output" />
      <Destination ToolID="19" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="84" Connection="Output" />
      <Destination ToolID="85" Connection="Input" />
    </Connection>
    <Connection name="#1">
      <Origin ToolID="82" Connection="Action" />
      <Destination ToolID="85" Connection="Action" />
    </Connection>
    <Connection>
      <Origin ToolID="85" Connection="True" />
      <Destination ToolID="48" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="85" Connection="True" />
      <Destination ToolID="46" Connection="Input" />
    </Connection>
    <Connection name="#1">
      <Origin ToolID="40" Connection="Question" />
      <Destination ToolID="41" Connection="Question" />
    </Connection>
    <Connection name="#1">
      <Origin ToolID="81" Connection="Question" />
      <Destination ToolID="82" Connection="Question" />
    </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>
    <Constants>
      <Constant>
        <Namespace>Question</Namespace>
        <Name>Macro Input (11)</Name>
        <Value />
        <IsNumeric value="False" />
      </Constant>
      <Constant>
        <Namespace>Question</Namespace>
        <Name>Macro Output (19)</Name>
        <Value />
        <IsNumeric value="False" />
      </Constant>
      <Constant>
        <Namespace>Question</Namespace>
        <Name>ControlParam.CP 1</Name>
        <Value />
        <IsNumeric value="False" />
      </Constant>
      <Constant>
        <Namespace>Question</Namespace>
        <Name>ControlParam.CP 2</Name>
        <Value />
        <IsNumeric value="False" />
      </Constant>
    </Constants>
    <MetaInfo>
      <NameIsFileName value="True" />
      <Name>BM_1</Name>
      <Description />
      <RootToolName />
      <ToolVersion />
      <ToolInDb value="False" />
      <CategoryName />
      <SearchTags />
      <Author />
      <Company />
      <Copyright />
      <DescriptionLink actual="" displayed="" />
      <Example>
        <Description />
        <File />
      </Example>
    </MetaInfo>
    <Events>
      <Enabled value="False" />
    </Events>
    <RuntimeProperties>
      <Actions>
        <NoCondition>
          <Type>NoCondition</Type>
          <Description>(Always Run)</Description>
          <True>
            <Action>
              <Type>UpdateValue</Type>
              <Description />
              <ToolId value="41" />
              <Mode>Simple</Mode>
              <Variable />
              <Replace value="False" />
              <Destination>23/Simple/Operands/Operand</Destination>
            </Action>
            <Action>
              <Type>UpdateValueFormula</Type>
              <Description />
              <ToolId value="82" />
              <Expression>+1</Expression>
              <Destination>85/Simple/Operands/Operand</Destination>
              <Mode>Expression</Mode>
            </Action>
          </True>
        </NoCondition>
      </Actions>
      <Questions>
        <Question>
          <Type>Tab</Type>
          <Description>Questions</Description>
          <Name>Tab (7)</Name>
          <ToolId value="7" />
          <Questions>
            <Question>
              <Type>ControlParam</Type>
              <Description>CP 1</Description>
              <Name>CP 1</Name>
              <ToolId value="40" />
            </Question>
            <Question>
              <Type>ControlParam</Type>
              <Description>CP 2</Description>
              <Name>CP 2</Name>
              <ToolId value="81" />
            </Question>
            <Question>
              <Type>MacroInput</Type>
              <Description>Macro Input (11)</Description>
              <Name>Macro Input (11)</Name>
              <ToolId value="11" />
            </Question>
            <Question>
              <Type>MacroOutput</Type>
              <Description>Macro Output (10)</Description>
              <Name>Macro Output (19)</Name>
              <ToolId value="19" />
            </Question>
          </Questions>
        </Question>
      </Questions>
      <ModuleType>Macro</ModuleType>
      <MacroCustomHelp value="False" />
      <MacroDynamicOutputFields value="False" />
      <MacroImageStd value="39" />
      <MacroInputs />
      <MacroOutputs />
      <BatchMacro>
        <OutputMode>AllSame</OutputMode>
        <ControlParams>
          <ControlParam>
            <Name>CP 1</Name>
            <Description>CP 1</Description>
          </ControlParam>
          <ControlParam>
            <Name>CP 2</Name>
            <Description>CP 2</Description>
          </ControlParam>
        </ControlParams>
      </BatchMacro>
      <Wiz_CustomHelp value="False" />
      <Wiz_CustomGraphic value="False" />
      <Wiz_ShowOutput value="True" />
      <Wiz_OpenOutputTools>
        <Tool ToolId="11" Selected="True" />
        <Tool ToolId="19" Selected="True" />
        <Tool ToolId="24" Selected="False" />
        <Tool ToolId="26" Selected="False" />
        <Tool ToolId="31" Selected="False" />
        <Tool ToolId="43" Selected="False" />
        <Tool ToolId="46" Selected="False" />
        <Tool ToolId="49" Selected="False" />
        <Tool ToolId="56" Selected="True" />
        <Tool ToolId="57" Selected="False" />
        <Tool ToolId="58" Selected="True" />
        <Tool ToolId="59" Selected="False" />
        <Tool ToolId="63" Selected="False" />
        <Tool ToolId="65" Selected="False" />
        <Tool ToolId="68" Selected="False" />
        <Tool ToolId="70" Selected="False" />
        <Tool ToolId="74" Selected="False" />
        <Tool ToolId="76" Selected="False" />
        <Tool ToolId="79" Selected="False" />
      </Wiz_OpenOutputTools>
      <Wiz_OutputMessage />
      <Wiz_NoOutputFilesMessage />
      <Wiz_ChainRunWizard />
    </RuntimeProperties>
  </Properties>
</AlteryxDocument>

 

Reply
0 Likes
nathan853
7 - Meteor
‎10-25-2019 08:02 AM

Hey guys, just an update.

 

I couldn't find anything related to a twin loop into a single batch macro.

 

So I ended up building another Batch Macro inside the first one. Little less simple, but worked flawlessly.

 

Thanks for the help!

 

 

Reply
0 Likes
learn more about the python upgrade coming in may 2024
Labels