7 Replies Latest reply on Apr 6, 2016 9:28 AM by Derek Chen

    Many duplicated data when connect two different excel sheets, please help!

    Derek Chen

      Hi, I'm a beginner of Tableau, I tried to use Tableau to do an weekly advertising analysis, but I found I got many duplicated datas when connect my excel data, here is how I did:

       

      1. I downloaded week 1 online advertising report and week 2 advertising report and then copy them into an excel file under two different sheets: sheet 1 and sheet 2

       

      2. I added the excel file as data source in tableau and connected the week 1 and week 2 sheet by "keywords" which is the search keywords I advertised

       

      20160330230732.png

      3, I started a basic analysis to see my advertising cost in week 2 and found the costs showing in tableau is much higher than the actual data, my average ad cost is about $1000 per day, but it shows $5000-8000 per day in tableau

       

      20160330231320.png

       

      4 I selected all and use "view data" to see the underlying data that make this wrong analysis, I found somehow the same keywords duplicated about 3-5 times, that's why the ad costs are wrong I think

       

      20160330231544.png

       

      I have no idea why it happens, please help

       

      I also added my workbook into this questions and I checked some column names into English