Compare output of two tools in a same workflow

[akshayhendre]

Hello All,

I am fetching some data from database in a excel file.

The first row of file has the number of records fetched from the database and second row onward I have the actual data (where second row has the header and actual data from 3rd row onward).

What I want to do is get the number from first row(number of records fetched from the database) and compare it with count of rest of the data(excluding the header on row-2). And if the count matches then only do the further processing.

Can anyone help me with this.

Thank you

[afv2688 · Accepted solution]

Hello @akshayhendre ,

how about this solution?

It compares the values on both sides and if it doesn't work wont continue processing

Regards

[akshayhendre]

Thank you @afv2688.

This is what I was looking for.

One last question, we want to check if both counts are same but in the Message tool you have used the condition "[Count]!=[Field1]", this is confusing to me.

[afv2688]

Hello @akshayhendre ,

the condition established is:

If the numbers on both sides are different then create the error, else process the workflow

Regards

[akshayhendre]

Thank you for the explanation and quick reply, really appreciate that 😀