How do I compare rows in a table? (meta data)

essalj666 — Mon, 12 Aug 2019 14:09:09 GMT

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?

topic How do I compare rows in a table? (meta data) in App Development