Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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 ๐
Hi!
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,
Isabelle