Output only a header row?

Seems like it should be simple, but I'm baffled.

I have a need to output datasets using the Output Data tool even if those datasets are empty.

In other words, I have 10 datasets that I output to .csv's for further processing. This further processing demands that 10 .csv's always exist, even if a given dataset is empty. So if a dataset is empty, I only want to output the header row... no other data.

Problem is, if an empty dataset is passed into the Output Data tool, it appears that it will not actually write a file. And if I pass in a dataset with just an empty row, I get a file but it has the header row and an extra row of delimiters for the empty data.

Anyone have any ideas?

Output

Accepted answers

OldDogNewTricks

@CharlieS - Great solution! I learned something new too. I originally went a longer way to solve the problem, yours was much better.

OutputEmptyFile.yxmd

All comments

CharlieS

Try using a dummy input that has all the necessary fields and use a Sample tool set to "First 0 rows" before the output. It will output a file with all the fields, but 0 records.

OldDogNewTricks

@CharlieS - Great solution! I learned something new too. I originally went a longer way to solve the problem, yours was much better.

OutputEmptyFile.yxmd

carl_steinhilber

This doesn't work for me, for whatever reason.

Selecting "First 0 Rows" in the Sample Tool results in an null resultset (of course), and, again, my Output Tool refuses to output a .csv from a null resultset.

My solution was to use the Formula Tool to set all the fields to a string containing their column name, then unchecking the "First row has column names" in the Output Tool. That's the only way I could get an output file.

AlteryxTrev

I had a similar but related problem and thought I would share my solution if anyone needed it. I have a file with 600 columns and I want a list of all of the column names.

My solution was to take the first row and transpose the data. This put all of the headers in column 1 and then I used a select tool to remove the data in the second column. Cheers!

j4jackycheng

I have the same question as @carl_steinhilber but i'm confused by the example from @OldDogNewTricks.

Not sure if that's due to Alteryx version different? i'm using 2020.3 x64 client.

With example from @OldDogNewTricks, there is no differences in behaviour with or without the Sample tool for me.

I found out for me, by default Alteryx would give the header in output even no rows returned, unless if you ticked the "Skip Filed Names" in the output tool.

The problem for me, i reckon is that because i used a formula tool to compute the output file name and file path, and the formula tool would ONLY works when there are at least one row of data in the incoming stream, in a scenario my SQL returns 0 rows, the file name would not and cannot be computed by the "formula too'", hence the output tool is writing it to nowhere! (instead of writing a header row to a sheet). The solution for me is to change my SQL query to union a dummy row, e.g. Field1 normally is = '123' , i'll dumy up with field1='No data found' , field2 = null, field3 = null... etc. It's not elegant but it works, the main problem is the lack of global variable in Alteryx and our usual way of using formula to compute file name.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703