topic Re: What visual to use? in Water Cooler

What visual to use?

sai_katare — Mon, 21 Jan 2019 07:59:18 GMT

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.

Re: What visual to use?

jonathandienst — Mon, 21 Jan 2019 08:11:18 GMT

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.