Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a following requirement.
Table 1 - 150 columns
Table 2 - 150 columns (same columns as table 1)
I need to compare these two tables and check if there are any values for these 150 columns that differ at a given minimum and maximum date selection.
Need help with edit script about how to process this data and also how can I visualize this?
Any suggestion would be a great help! Thanks in advance.
Something like this, perhaps:
TCompare: CrossTable(Field, Value1) LOAD 'Table1' as Source, * FROM Table1; CrossTable(Field, Value2) LOAD 'Table2' as Source, * FROM Table2; Compare: LOAD RowNo() as RowID, Source, Field, Value1, Value2, If(Value1 = Value2, 1, 0) as Flag Resident TCompare; DROP Table TCompare;
Now you can report all the fields and values where the flag is set to 1.
Something like this, perhaps:
TCompare: CrossTable(Field, Value1) LOAD 'Table1' as Source, * FROM Table1; CrossTable(Field, Value2) LOAD 'Table2' as Source, * FROM Table2; Compare: LOAD RowNo() as RowID, Source, Field, Value1, Value2, If(Value1 = Value2, 1, 0) as Flag Resident TCompare; DROP Table TCompare;
Now you can report all the fields and values where the flag is set to 1.