Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
eduardoramiro
Contributor
Contributor

How to use only data with a specific date in the expression editor?

Hi!

Is there a way to do something that performs the same function as this "Where" in an expression editor?

 

where extract_dt = (select min (extract_dt) from governanca_dado.fsimage)

 

My column "extract_dt" has two dates, one is recent and the other a date from the last month. I have these dates so I can compare the old data with the current one and get a sense of the changes.

I wanted the expression to use only data that have that minimum or maximum date, for example, to generate data.

Labels (2)
1 Reply
Bunim
Contributor III
Contributor III

aggr(only({<extract_dt={$(=min(extract_dt))}>}extract_dt),extract_dt)