Left Join outputs blank sheet

[mazizpour]

Hi, 

I have a setup where I compare weekly data and have to show new supplier in a new sheet on the same output file. I encounter a problem when there is no new suppliers in the left join. The output is blank and I want it to write the Column Header and " No Match" below it if that's the case as opposed to a blank sheet with no header. 

The screenshot shows you my join setup and the formula tools have a formula to append today's date to the file name.

[rzdodson]

You can create a generic Text Input tool that contains the "No Match" placeholder, and then just union it to the output of your L anchor.

[Raj · Accepted solution]

@mazizpour 
you will need to have a text input tool with all the place holders and then you can union it with the output of L anchor and with record and a simple formula tool after it will get you the output

Let us know if you have any issue.
can help with the flow if needed.

[Raj]

@mazizpour reffer this
Hope this helps.

Mark done if Resolved.

[mazizpour]

thank you!!

[mazizpour]

Raj, I maybe doing something incorrectly in here because testing the flow with incoming data in L anchor, I still see the " No Match" row I created. I want to output "No Match" if there's no incoming data to L anchor, else L anchor data needs to be written to the sheet.