Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
aggr(only({<extract_dt={$(=min(extract_dt))}>}extract_dt),extract_dt)