7 Replies Latest reply: Mar 20, 2018 6:34 AM by youssef belloum RSS

    Combine different sources in the data manager

    Pascal Dijkshoorn

      Hello,

       

      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.

       

      Has anyone a solution for this?

       

      Thanks in advance