I am working with a big shipment database in Qlik sense. This data comes from the data warehouse. In this database, certain customer names are not filled in correctly. So i have made an excel file with two columns: "wrong customer name" and "new customer name". Now I want to add a formula in the data manager with the following conditions:
- If the customer name from the data warehouse exists in the column wrong customer name, the field should show the new customer name
- If the customer name from the data warehouse does not exist in the column wrong customer name, the field should show the customer name from the data warehouse.
This way i will have one new column with all the right customer names from the data warehouse combined with the new customer names from the Excel file.
I tried to start with this, but i noticed that you cannot access column names of another source in a calculated field in the data manager.