NEW Action CHECK IF TABLE EMPTY

1

The EITHER TABLE will allow you to assign you and alternate table if the current table is empty or the alternate table has data.

Sometimes, depending on the data in another table, the table can be empty with some input file data/actions or with other input it can contain data. It would be handy if there were two options for the ACTION when checking the status of the table.
If the table to be checked is EMPTY, use table A but if the table has data, use table B.

I had the requirement to create a lookup table that had data sometimes and no data other times. Now I wanted to use the LOOKUP action to check data in that table but when I did so if there was NO data, I had an error in the workflow if the table was empty. I had to setup a complex sequence to avoid the error and have the workflow operation correctly if the table had data or if it was empty.
The following is with data in TABLE Get Holiday data:

image
image1074×489 25.3 KB

If there was no data, the flow looks like:
image
image1063×442 23.8 KB

The final table, which must contain the resulting data is “Combined data Payroll Download file with HOLP Corrections”

2

Do I understand it correctly, that you wanted the “Lookup” action work correctly even if the lookup table was empty?

If yes, in this case, the error was probably caused by the “Lookup” action because it couldn’t find the columns in which to look up. As a solution, you can generate a dummy lookup table with no rows but exactly the same set of columns as when the lookup table is not empty. Then, of the original lookup table is empty, substitute it with the dummy lookup table.

dummy-lookup.morph (4.3 KB)

3

I did solve the problem as shown in my example. I was hoping for a simpler flow. Thanks

4

A couple months ago we’ve added the “Skip on condition in another table” action. With it the flow is simpler (see below).

skip-lookup.morph (3.6 KB)

5

This a very handy action.
I use it all the time