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...

Output

Common Use Cases

Data Investigation

Accepted answers

nagakavyasri

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

Screenshot 2024-02-26 121439.png

samxhander09

@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!

All comments

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

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

Screenshot 2024-02-26 121439.png

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335