I am currently working on a process where I am trying to find "mistakes" in my data and make a new table depending on the certain mistake I am trying to catch, although, frequently the tables are of size zero because there are no incorrect values. My question is: Is there is a way to record the size of the newly created table and record them in a different file. For example, if table001 is empty, it would record on a different excel file as table001size=0? That way the user can do one check at the end and knows exactly what tables to look at.
If I understand your question correctly, you can use the Count Records tool in the Transform Tool Palette. This will return a Field [Count] with a single value, 0 if the table is empty.
You can then write this value to your output Excel file.
