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