Hi
I have tried inserting the "Block until done" tool at the places highlighted by the red arrow. But the output for the 1st excel file is not appearing.
Any help is appreciated!
Thanks
Vanessa
Hi @Vanessa_JWS
While configuring the output tool, there are 4 options,
Please use Overwrite Sheet or Range.
If my guess is right, you might be using the Overwrite file (Remove) where the 1st sheet is removed when saving the second ouput.
Many thanks
Shanker V
@Vanessa_JWS Are you able to see data in the below section? Are there any errors or warnings showing in the result window?
@ShankerV - Thanks for helping to look into this. I have checked all 4 outputs and for all 4 outputs, "Overwrite sheet or range" has been selected.
@binu_acs - Yes, I am able to see the data it's just that the output is not working
@Vanessa_JWS are you writing the output to the same excel in different sheets? If yes can you check the sheet name in both the output tool and make sure they are different
Yes - it's different. Initially it's the same and I amended. I am not sure whether that is casuing the issue but I have tried closing down and re-opn the workflow and it still doesn't work
@Vanessa_JWS Can you share your output configuration from both the output tool?
@binu_acs : Here they are:
Output 1
Output 2
This is fairly difficult to troubleshoot without considerable more details. Do you have a "take filename from field" option selected? My hypothesis:
1) you are sending in the same full path to both output tools with use full path selected. In this scenario output 2 is overwriting output 1. BUD would have no effect here since once output 1 is done writing output 2 overwrites it.
2) you are modifying the full paths or filenames differently then you expect - the file may be being generated but with a filename which makes no sense.
3) there are no records flowing to one of the output tools. Check your logic on joins/filters/etc.
Those are the usual suspects.
@Vanessa_JWS Seems to be your configurations are correct. After you run the workflow can you check the result window where you will see the names of the files created. Check whether the first file was created with the sheet name 'OS Bill to listing'. Please also check for any errors. Below is an example of the result window
@apathetichell - thanks I have managed to resolve this and deleting the output tool and re-inserting it with the same configiration
