Alteryx_Macro

[Mukeshy12390]

Hello Everyone,

I have been trying to create a dynamic solution but facing a bottleneck.

I will try to explain in detail: -

I have one mapping file  -- > It has 4 fields and  number of row is not fixed

• 1)FileName                [input Full path with sheetname]
• 2)Header name
• 3) Filter_Xml               [To change filter through mapping]
• 4)ChangeData_Xml    [To change data type through mapping]

so here is the flow  -- 

I will update all those 4 details ---> When I run workflow ----> it should open input file one by one and update XML [3 and 4].

I have created a Batch macro. but creates duplicate data [original record gets multiplied by the total row in mapping].

• Macro has 3 parameters 1 for file and 1-1 for xml  [ header is included in both xml field]
• I have selected group by option as well with filename.

in my logic it seems input data gets load on each row of mapping.

Anybody could suggest the flow, and how it can be done would be great help.

Thanks,

Mukesh Y

[danilang · Accepted solution]

Hi @Mukeshy12390 

Can you give us some more detail?

By design, a Batch macro will process the input data once for each row of control parameter data.  The results of these iterations are unioned on output.  If you're trying to perform the series of xml operations sequentially to a single file, you might want to look into using an iterative macro

Again, more details about your requirements would help us help you.

Dan

[Mukeshy12390]

Thanks Danilang!

Yes, I understood later that It can't be possible with current mapping and Batch macro. so I changed the mapping and workflow logic a little bit [basically I grouped it into one Row] and it works🙂