Add row when no data in output and remove null row when there is data in output file

[srk0609]

Hi,

PFA explanation and Alteryx WF 

I used following tools to generate null value row so that I can get output file with only column values when there are no matches.

But this is creating Null row even when there is match between files and there is actual output. I want to add formula which will generate single Null value row only when there is no matching data and in case there is matching data and output file has some rows then it should not add Null value row

Required

No matching fields hence Null value row required

Not required

There are matching fields hence Null row not required

Please help. Thank you

[grazitti_sapna]

@srk0609, you can try to use something like this when there are no data use count records along with the filter before output.

1. When no data then you can do something like this.

2. When there is data then you can save the output normally.

You did not provide the input files so I was not able to implement something to the existing logic.

Thanks!

[srk0609]

Hi Sapna, here are the files can you please implement using this files? I understood that I have to use Formula tool but not sure what formula. Thank you for help.

[Emmanuel_G · Accepted solution]

Hi @srk0609 ,

You will find my test with your files attached.

My response is in a yellow container. And my reasoning is similar to @grazitti_sapna 's about adding a null row when you have no join output data.

Let us know if it works the way you want.

[srk0609]

Thank you Emmanuel

[Emmanuel_G]

@srk0609

You're welcome dear !

Cheers !

[srk0609]

Hi Emmanuel the append tool doesn't work if there are more than 16 records coming into source. I'm getting following error. Could you please let me know what to do?

[Emmanuel_G]

Hi @srk0609 ,

To resolve that, you can enable all appends by clicking the option on bottom left as the screenshot shows.

By default when you have more than 16 lines with which the tool must make a Cartesian product in the source. it will generate an error.

Let me know if it works.🙂

[srk0609]

Thank you, I selected 

[Emmanuel_G]

@srk0609  Yes or  warning. Just as you want🙂.

Feel free to mention as a solution so that it helps other users in using this tool in the future.