Is there a method to compare two columns (feature_purchased_date and email_sent_date) belonging to different tables? I want to retrieve records where feature_purchased_date from the "feature" table is greater than email_sent_date from the "recipient delivery logs" table.
Thank you in advance
Topics
Topics help categorize Community content and increase your ability to discover relevant content.
Hello, @rvnth. Do those tables have any field for the reconciliation? If they do, you can query one of the tables, enrich it with the other reconciliating by that field and do a split with the condition feature_purchased_date on or after email_sent_date.
