I'm evaluating a trial version of data generator and have a few scenarios that I'm wondering if the product can handle. One scenario is offsetting a date based on a value in another table. For example, you have a hire date in an employee table. In another table, you have a record of employee sales that includes a date of sale for that employee. I want to make sure that all of these are later than the hire date. Is there a way to offset from that column which resides in a different table?
Comments
1 comment
-
Hi there,
I'm afraid I can't think of a way to get this working with a column from another table.
(There is an example on how to offset based on a date in another column of the same table here: https://www.red-gate.com/hub/product-learning/sql-data-generator/generating-realistic-dates-using-sql-data-generator-and-python)
I don't suppose there is any other date column in the same table that may indicate the start date or an appropriate date to start from?
Add comment
Please sign in to leave a comment.