Output Data issue

Hi all,

I would like to output below data in excel files for each Effective date (3 output files from below example), Effective date column not require in the output files

Each file will always contain header from cells A1:B2 (highlighted) .

I've used "Take File/Table Name From Field" & select "change Entire File Path" looking up "Effective Date" field.

However Output is skipping Row2 for each date files, e.g

Is there a work around for this issue? Thanks for all the help here!

Output

Tips and Tricks

Best Practices

Dynamic Processing

Accepted answers

BenMoss

Hi @jchan58,

My understanding is that you are expecting the Name and EmpID headers to exist underneath the A and B headers in each of the files too, is that correct?

If so we could achieve this very simply using the example outlined in the attached workflow.

Ben