how to report (compare) on two tables to find the changes

[Johny1]

Hello Folks,

I have two two import sets tables (Eg: previous & current) having 4 fields each. I need to compare the previous and current month table data and need to put the changes on the report. Is that possible?

Waiting for your suggestions or inputs.

Thanks in advance..!

Regards,

Johny

[Surendra Raika1]

Is there any key shared between these two tables .. changes with respect to which key field?

[Johny1]

Hi Surendra,

yes, the tables shares a common 3 field key. (eg:field1, field2, field 3)

Thanks

Johny

[Abhineet Singh]

Hi Johny,

You can create a custom table with fields Unique ID, OLD (field name), New (field name) and build a scheduled job with select a primary key (qualifier- Unique ID) to compare records of different tables and then store it to custom table.

Example

Unique ID || Old IP Address || New IP Address

10001           || 192.168.1.1           || 10.1.1.1

Hit like, Helpful or Correct depending on the impact of the response...

[Surendra Raika1]

Alright, so the fourth field is where you are expecting a change and want to report that ..

Create a Database view (join the tables based on the key(s)) -> get the fourth variable from both the tables on the view.

Create a report based on this view and in where clause compare the 4th variable from both tables (field4Table1 != field4Table2)

I hope that helps.