Splitting Output based on value in column

[GHaines]

Hello,

I have been given this workflow that I need to improve to spit out all of the outputs in one file based on the AFE column value. Currently, the workflow is summing all values together and presenting one total at the bottom of the output. My goal is to pair the output header for each AFE with an individual table for each AFE. I have been having a hard time with getting the workflow to sum based on the AFE number, as well as splitting it into the outputs in the order that I want. I have attached some sample data to my workflow to visualize what I am describing. Thanks for the help!

[mceleavey]

Hi @GHaines ,

You probably want to batch each AFE number into a batch and create the tables before putting them together.

I've created a batch macro which does this and outputs the following:

I hope this helps.

M.

[afv2688 · Accepted solution]

Hello @GHaines ,

are you looking for something like this?

Regards

[GHaines]

Hi Mceleavey.

This is a big help. Thanks for looking into this for me.

[GHaines]

Hi @afv2688,

Thanks for the help, this community always impresses me when I can't find a solution.

I don't want to bother you, but do you think you could help me subtotal the amount column for each AFE in the output? 

Thanks again!

[afv2688]

No worries @GHaines ,

here you go 🙂

Regards