Do not want my output file to be updated if no records

[TANIJD2021]

Hi All,

I have the below workflow and I want the output file to stop updating if there are no new records.

Right now it is updating my excel output every time I run it.

[michelle_mathews]

Hi @TANIJD2021 , there is a workflow example in this community post which should help solve your problem! 

[TANIJD2021]

Hi  michelle_mathews

What should be the condition for the test if I want to check that there are no new records in the file?

Thanks,

Tani

[flying008]

Hi, @TANIJD2021 

Maybe you can try this tool option:

[TANIJD2021]

But what condition should i give here in the below tool

[Emmanuel_G]

Hi @TANIJD2021 ,

Find attached a solution to this issue.

I used the message tool to stop the records in the downstream tools based on condition on the records.

You can see the configuration in the workflow attached.

[TANIJD2021]

Hi Emmanuel_G

Thanks for your help.

I want that when there is the same number of records the next time I run the flow it should give an error and stop updating the output file.

Like if there are 2 records and again the next time I run the flow there are the same number of records then it should error out and not update the output file, right now I can run your sample workflow a number of times without an error with the same number of records.

The request here is to not update the file when there is the same number of records.

Thanks,

Tani

[Emmanuel_G]

Hi @TANIJD2021 ,

In this case, you can edit the formula in message tool with the number of records of some input file as configured below.