Data Comparison between two tables

Wed, 09 Dec 2015 05:58:40 GMT

Hi All,

I am new to Qlik View. And I have written a Macro in Excel which is very tedious.

I have two tables which don't have similar structure.

Such as Table - 1 has columns A,B,C and Table - 2 has columns D,E,F,G,H.

I define the mapping for comparison purpose in the Table - 3 in the following format.

Source Col Target Col Data Type Formatter

Table 1A Table-2E Numeric NumberFormatter(9,5)

This table tells what columns to compare and what type of data is available in the column. Before comparing if the data in the Source and Target Tables need to be formatted before the comparison.

Please advice what is the best way to approach this problem.

Thanks in advance,

Alok

topic Data Comparison between two tables in QlikView

Data Comparison between two tables