Using the Append Fields Tool, you can append the fields from a source input to every record of a target input. Each record of the target input will be duplicated for every record in the source input. In this example, all Distribution Center records are appended to each Customer record. ...
But when I swap to overwrite the newly created dataset, I get errors for the null dates and it won't publish over the dataset. I changed my date fields to strings and it worked, but I am not looking forward to adjusting dates in all workbooks. I'm having the same issue as Emil ...
I choose to use an append fields tool to add every possible rule to every ticket and column. You can then join this to the set of tickets to produce the tickets where no field passed any rule (the unique tool in my workflow is not needed - bad tool golf!). For part 2, you need...