Hi there, I just tried to re-create this scenario, when both Excel files and CSV Files have only the header defined, I see both output nothing in their output (see validation screenshot below).
It’s important to recognize that the output minimum is for the number of output views, not the number of documents being output. This is with the defaults for both (other than the Excel Parser checking the Contains Header option). It seems you may have unchecked the “Ignore Empty Data” option in the csv parser, that is what will produce this output. The difference is that with Excel, if we don’t have any data visible after the first row, we won’t even potentially have data to push.
One possible way to address this, specifically with the Excel Parser is to do a precursory check via the excel parser with Contains Headers unchecked and then use a gate to count the output documents followed by a router based on the count with the count being zero, you can use a JSON Generator set t [{}] to generate the empty document and have the other go through and re-read the file and re-parse it with headers when the count is greater than one. I’d say it’s unlikely that there would be added support to push out an empty document at least in the near future, but this configuration might get you through in the interim (I’m attaching an SLP plus the csv and excel files that I’ve used to achieve this)
test_excel_some_data.xlsx (8.4 KB)
test_excel_some_data.csv (59 Bytes)
test_excel_no_data_but_headers.xlsx (8.4 KB)
test_excel_no_data_but_headers.csv (32 Bytes)
Excel Parser No Output When Just Headers_2022_10_11.slp (15.0 KB)
