This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The solution worked. Thanks. I have a follow-up question on this. I have a workflow that I execute prior to a data load for quality check and within this workflow I write to a single output file say "QC_Report.xlsx" but several tabs and I used the option as suggestion by you. I have the output option as "Overwrite Sheet (Drop)". This works. However, if the output file had data written to a tab "Missing Definitions" from a prior workflow run and during the current load there are no records to be written, then the empty tab will remain in the output file.
If the file name does not change with each workflow run but I want no empty tabs, how would i go about it? If I don't want to change the file name in every output tool, how can I generate a new output file using a formula tool and still be able to use the new file name along with the "Null" option for the suffix?
I have the exact opposite problem, where I want to write a file with no lines of data but am taking the file name from the data. I can create a null row and append my file name to it, but this results in a written file with one (albeit empty) row.
Do you know a way to write a blank, dynamically-named file?
I have a series of datasets that need to be cleaned and written to files. Each file MUST exist for validation purposes. But because of some nuances with the platform that imports the data following the cleaning, empty datasets need to be output as empty/blank (dynamically-named) files or, in certain circumstances, files with only a header row.
But I can't get Alteryx to write a file if the dataset is empty.