Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi! I am trying to do the Core Designer cert. When trying to do part 4 of the practical, I end up with 980 rows and not 985.
I have inferred all data types as suggested in earlier steps.
I am doing an inner join across all three datasets and have tried both pre-filter and post-filter on the year column with >= 2008 and =< 2012 as my conditions.
Not sure what I am missing - any help much appreciated 🙂
Thanks for reaching out. You're on the right track. On stage 3 (after the merge), your dataset should have 985 rows. Yet, on stage 4, it's normal to go down to 980.
You can keep going obviously 🙂
Have a nice day,
Post a Question