Left Join outputs blank sheet

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.

Screenshot 2024-04-01 105147.png

Output

Accepted answers

Raj

@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.

All comments

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

@mazizpour reffer this
Hope this helps.

Mark done if Resolved.

832.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703