I created a mapping file with alternate names in the first column, and the desired name in the second column.
Both of the data files have Company Name. The Company Name in one file is the desired name. The Company Name in the second file may have one of the alternate names, included in the first column on the mapping file.
I used the following statement to load the data:
Mapping Load x,y from alt_names.xlsx
(ooxml,embedded labels, table is Sheet1);
The Company Name list in the Qlikview file shows both names, rather than the desired company name.
I would appreciate suggestions to correct this situation. Thanks in advance.