วีดีโอ

how did we transfer this data without errors?

Good video, it's so nice that you used the dataset of this platform.

How do you get the "changes" and the revision history to show on your tableau, mine only shows the table details, I'm on Tableau Professional Edition 2024.1.4

It's a good video, so more videos like this one with daily life examples at Tableau Prep Builder. if you share data sets or files much better please.

how can do this in excel.

Enjoyed! Thanks for the Group trick 😊

My god, it is so beautiful, thank you for sharing this quick, nice, and easy way of manipulating the data prep.

"Expression '[DONTSHOW-JOIN-15f054d6-b9aa-4ee8-8cfd-c67b2c3980a6] == 1' has one or more errors" I am getting this error after joining tables.

First I thought the hidden 'Rank' field wouldn't show up in the output. Wouldn't that be cool though?

Also, when I union at 2:32, I'm getting 7 Mismatched fields instead of just SortOrder. Why?

Dunno if it's me but I keep getting a stupid error, "System error: An error occurred while communicating with data source 'LoomDataSource'" when changing Stage names.

You forgot to mention that you also grouped [Location] in 3:47

I'm getting completely different results than yours. I think it could be because the data source has been updated or something. I done everything in this video step-by-step and my results are still showing different answers.

What a great challenge! You did a wonderful job explaining the lookup function, [Sign] and [Trend]. Thank you!

What a great challenge! Thank you for sharing the solution video.

Can you please show us how to do this in Excel? The date format will not change at ALL! I tried to change the format of the cell to a date format and even used the text-to-column to change it to date as well and they just don't respond to any changes. Very annoying and I would LOVE some help to do this. I was able to figure everything else out. Thank you!

Thank you so much, really appreciate

I decided to use a branch for each subject with two joins after because I was getting null in the pivot step. The aggregate step following the pivot was crucial to the solution. The video is super helpful, thank you!

Ah! Unpivot is what I needed to do. And the unpivot needs to be done after removing [Grade], otherwise you'll get bunch of nulls.

Awesome video, so could you share the files to replicate the example, I think so we can understand better if you don't mind, I'll appreciate it.

The purple cursor looks good 😀

I'm back 🙂

Subbed&Liked!! This channel needs S M Z E U S!!!

I definitely counted zeros for M and B too :) Good to know there's a Power() function. It was nice seeing how you used the replace() and contains() functions. Thank you for creating this video!

I learned about the Rename Fields feature. So cool!!!! You can rename a lot of fields all at once. Changing the Data Type for 'Account Holder ID' to String was a simple and smart solution.

I did both pivots in the same step too. But, the wildcard search to pivot was new to me. Also, I did ABS( [Difference in Average Rating ] )> 0 AND ABS( [Difference in Average Rating ] )<1 to get 'Neutral,' where I could have just used Else :) Thanks for the video!

The format of my dates is different. I have MM/DD/YYYY. How can I change it to DD/MM/YYYY?

Hello! I'm stuck @4:06. I got through to the "duplicate DOB column" step, but then The Convert Dates - Custom Fiscal Year options won't show up no matter where I look. I'm in Tableau Public.

Hi! Thanks so much for sharing the solution. I'm following this to do the challenge but got stuck with the Join 3. For some reason the tables doesn't join correctly, there is no match results for me which I couldn't understand. Is there some potential reasons that you could think of?

You guys need to fix the sound check on your videos, they're almost muted

Most underrated channel, thank you for giving free knowledge

That was one heck of a challenge .

we need to see the changes you made to the targets table

Want to report how Oregon pension fund was heavily invested in Russia and lost 75% of its invested funds?

any solutions in python? would love to see how the fixed window functions are executed in pytthon

Amazing! Very elegant solution. This just saved us so much time.

man- ‘sup?.you sharedo utstanding -=)

the challenge needed to be explained better. it was a good exercise none the less

Very good explanation ! Thanks

holy crap, even a free tool like easymorph has a step to do filldown. I am horrified to see this.

Could you do these challenges in power query as well please.

I used REGEXP to extract codes from commentary

Hi can we do same project in tableau desktop to get same output.

This series of tutorials is impressive!

Great video! What if you don't have any fields that could help you infer the order of the values? In this case, let's say that you simply don't have the [Row ID] field. Is there any way to create such Row ID or internal Index within TP?

Hi There, i'm new to Tableau, i'm tying to create Dashbaord for Incident management team, do we really need Tableau Prep for calculating SLA or Can we do it in Tableau Desktop?

I enjoy your vid, but could you increase your audio? I'm guessing you're using a mic that is further away from you. I would recommend a lapel mic for a boost in clarity. Tks.

Thank you for the detailed explanation!

Amazing Solution, easier than one i used

nice content