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

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

Add row when no data remove data when there is data in output file.yxmd

Tips and Tricks

Custom Tools

Common Use Cases

Help

Join

Data Investigation

Accepted answers

Emmanuel_G

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.

Add row when no data remove data when there is data in output file.yxzp

All comments

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.

product_price.csv

product_quantity_match.csv

product_quantity_nomatch.csv

Emmanuel_G

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.

Add row when no data remove data when there is data in output file.yxzp

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.

Quick Links

This months top contributors

mceleavey 382

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262