Last answered:

13 Sept 2023

Posted on:

26 Mar 2021

1

Excel sheet is incorrect and different from the one in the video lecture

Please note that I have different results when I get the two excel files in Tableau and I notice that the two excel sheets in the video is different from the attached ones so can you advise regarding this one

10 answers ( 0 marked as helpful)
Instructor
Posted on:

28 Mar 2021

0

Hi Peter,

Thanks for pointing this out. We'll take a look at the issue and resolve asap.
Best,
Ned

Instructor
Posted on:

30 Mar 2021

0

Hello,
I took a look at the sheets but didn't find the difference. Why do you believe the two sheets are different, please?

Posted on:

30 Mar 2021

0

Please go through the video and you will find there is a difference resulting in the first at the moment of turning to the left join, i see it from the first rows in the video and the one i have which there was a difference but when continue it gives the same result and I already finished the course, so no problem.

Thanks

Posted on:

12 Apr 2021

3

Hi,

I have the following issue when I try to connect both files. Do you know how it can be fixed?

Thanks in advance! :)

Monicaimageimage

Posted on:

13 May 2021

0

Hi,
I encountered the same issue and would also like to know how it can be fixed.
Thank you!

Posted on:

29 May 2021

0

Hi there,
I am encountering the same issue
image.png

Posted on:

29 May 2021

7

Hi,
I found the solution. Just posting it here. Once you have Audiobook sales on the right, just click on open. Then drag Audiobook reviews and they end up getting related.
image.png

Posted on:

28 Jun 2021

3

I have the same issue. Once the left join is selected, most fields become "Null". I am assuming the resource files used in the video are different from that available for download.

Posted on:

01 Aug 2021

0

I found a decent way to learn, despite encountering the "null" error described above is to download the lectures Tableau data file (from the "Performing a Numbers Check - Attempt 1 - link"). Just so you can have the correct data from that lesson onward. The lessons up to that point will obviously have already been completed within your Tableau file up to that lesson, but you could move along with the other lessons. It's not perfect, but it's a suitable workaround in my opinion.

Posted on:

13 Sept 2023

0

The excel files are wrong. For the same transaction, the audiobook name in sales and in reviews table should be the same. 

Submit an answer