Hi.I have a job doing a daily extract of metadata on all apps in production.
In order to assess data quality of most recent load, I want to compare to earlier days.
But I cannot get i t to work.
I have a table looking like this
What I want is something like this:
- one line pr app
- masures from the most recent date in the three last weeks (appsize0-2, columnCOunt0-2 and table_Count 0-2)
- and the max load date.
How can I do this?