Batch Macro

[rajatjain]

I have a workflow in which i am using a formula tool where i am calculating one field i.e.   A =  0.25 * B 

B is the field already present in the data flowing in the formula tool.

I want to repeat the whole process using values of 0.75, 0.5 so that i can get 0.25 * B, 0.5 * B, 0.75 * B  in all the columns. I can't use the same formula tool since i have to use the same A.

How to modify this value of 0.25 in the formula tool to a predefined value set given by me so the whole records get multiplied with all the set values and the columns are stacked  next to each other?

[patrick_mcauliffe]

@rajatjain can you post your progress so far with some dummy data?

[rajatjain]

Here in input i have 4 rows with values 0.25, 0.5 , 0.75 , 1

and in the formula tool i am doing multiplication with 4 as a start

which gives 1,2, 3, 4 as the output

i want more columns which next multiplies the values with 8, 16, and 32 and so on... This is the basic idea!

[patrick_mcauliffe]

Hey @rajatjain I think this is what you're looking for: a batch macro where the multiplier is determined by the batch/control number.

Then, cross tabbing that into a table where the column number is the control number.

Take a look and be sure to mark it as solved if this answers the question.