compare two columns from two different tables | Community
Skip to main content
R
rvnth
Level 5
June 20, 2024
Solved

compare two columns from two different tables

  • June 20, 2024
  • 1 reply
  • 579 views

Hi there, 

 

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Heku_

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.

Hope this helps!

Regards.

1 reply

Heku_
Heku_Accepted solution
Level 5
June 20, 2024

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.

Hope this helps!

Regards.

    Terms & ConditionsAccessibility statement

    Loading footer...