Alteryx_Macro

Question

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 Answer

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