Save output to Excel file as "No Records Found" instead of having only header columns.

Hello Guys,

I have a scenario where in when there is no output, instead of writing the output excel file with only the column headers, it should just have a note in the cell A1 as "No records found"

I have attached a sample workflow which takes input from a excel file, then filters for data where Age<20. if there is no output matching this criteria, I want the excel output file to have only one cell A1 which states "No Records Found".

Any idea or workaround?

Thanks

Sarathi

Alteryx Workflow.yxmd

Output

Accepted answers

JoshKushner

This workflow will unite the response "No records found" with the data and decide to keep or discard the response if there is populated data or not.

Flow:

Results:

Multi-Row Formula:

No Records Found.yxmd

All comments

JoshKushner

This workflow will unite the response "No records found" with the data and decide to keep or discard the response if there is populated data or not.

Flow:

Results:

Multi-Row Formula:

No Records Found.yxmd

Sarathi_57

Thanks Josh,

That worked fine.

One more quick question.

I know we can write the data alone without headers using a Table and Render tool to save it to a Excel file. But Is there a way that we can write to excel file using a Output tool without having the column headers and having the data only?

dawnh80

Great example! I looked for this solution for a user and shared your workflow.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703