Core Designer Certificate Stage 4

hazelellender
Level 1
Core Designer Certificate Stage 4

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 ๐Ÿ™‚ 

0 Kudos
1 Reply
IsabelleG
Dataiker

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

0 Kudos

Labels

?
Labels (1)
  • i