Output Data issue

[jchan58]

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!

[haroon_sa]

Hi @jchan58

I attached my file,i'm using select tool module to avoid last column,hope it helpful for your question.

If any queries,Let me knnow

[jchan58]

Hi , mind attach the file again? am not seeing it.. thanks

[jchan58]

sorry this is not what I'm looking for.

[haroon_sa]

@jchan58

Did you got the file?

[jchan58]

got it thanks, but it doesn't address to my issue. thanks anwyay

[BenMoss · Accepted solution]

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

[jchan58]

This is Perfect.  thanks