1 Reply Latest reply on Apr 14, 2016 1:41 AM by Łukasz Majewski

    How do I overwrite data from a big database with a simple excel file?

    Louis Bertrand

      Dear All,

       

      I have a big database that is plugged into Tableau and it is 99% correct.

      For the 1% wrong, I have correct information in an excel file.

      Lets say the data is a list of ID and sales amount

       

      I want to say to Tableau:

      - If this ID is part of the corrected excel file, then show the sales amount of the corrected excel file

      - If this ID is not part of the corrected file, then show the sales amount of the big database

       

      It looks easy ... but I am having a hard time merging the database, even after creating the relationship on ID between the database and the excel file.

       

      Does anyone have an idea on how to solve?

       

      Thanks,

      Louis