No data in output file

[samxhander09]

Hi! Has this ever happened to any of your cases?

I ran my workflow in the designer - No error -- output data all written to where I want them to be.

Little backround: I have 4 output columns in one file A,B,C,D

Three streams get save to A,B,C

While D has another 3 streams for output, share 1 tab in output file but is cell-range specific

Ex. Stream 1: Output.xlsx|||D$C1:P2

Stream 2: Output.xlsx|||D$C30:P30 .... so on

For Sheets A,B,C, records can be seen when opening the output file but when it comes to D, no output data even when it says 

6 records were written to "sampleserver\Output.xlsx" (D$C30:P30)

6 records were written to "sampleserver\Output.xlsx" (D$C1:P2)

.. so on

What could I be missing or should be checking? I'm very much confused... 

[samxhander09]

Sorry, mistype, I have 4 Sheetnames in one (output0 file A,B,C,D

[nagakavyasri]

@samxhander09 there is no sufficient input given for the 6 records to be displayed in the output:

6 records were written to "sampleserver\Output.xlsx" (D$C30:P40)

6 records were written to "sampleserver\Output.xlsx" (D$C1:P10)

Change the rows  numbers and try again

[samxhander09]

I edited it to $C11:P15 and $C20:P24 still the same...

[nagakavyasri]

@samxhander09 but you have 6 records as output. So edit to $C11:P16 and $C20:P25. The no. of output records should be same or less than the specified sheet range

[samxhander09]

@nagakavyasri tried, unfortunately it's still the same..

[nagakavyasri · Accepted solution]

@samxhander09 Can you delete the output and try again (or) select this option in Output data tool:

[samxhander09]

Hi @nagakavyasri , tried to isolate the issue by creating a new output file, same configuration as the one you appended but still to no avail.

[samxhander09 · Accepted solution]

@nagakavyasri hi again, i tried to create a new output file again, from scratch and made sure there's no merged cell or any weird/additional format on the output template, I also re-configured output data tool to overwrite sheet and range. It worked! Thank you for all your inputs!