I want to do IF statement: If my resource runs out of data to process do x actions. How do I do this? I tried to use Ignore errors but that did not work.
Hope that really answered your problem. Can also use the "Select Records" command, change the Table to the second one and add any filters you need. This will return all records in a list and using the Foreach will get the job done.