Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

Core designer certificate

ccomes3007
Level 1
Core designer certificate

Hi,

I am trying to do the project for the core designer certificate. I have load the 3 dataset but when I'm doing the join between the three dataset I have 955 rows and not 985  rows as it say in the hand-on instructions.

There is any problem with dataset?

Thank you for your help.

0 Kudos
2 Replies
SeanA
Community Manager
Community Manager

Hi @ccomes3007 , I can confirm that you should indeed have 985 rows in the output to the Join. Since you have fewer rows than expected, you might want to check:

- Are you correctly filtering for the required years?

- Are you using the correct type of Join?

- Has Step 2 been completed? Do you have numeric columns stored as numbers?

Dataiku
crisdrgmr
Level 2

Hi @SeanA Sean, I have the same issue, but getting 2940 rows. I have tried different join methods, I have filtered for years before the join as well as after the join and checked it in the output dataset, numeric columns are stored as int, but whatever I do, I cannot get less than 2940 rows in the output dataset ๐Ÿ˜ž

Any suggestions, please?

0 Kudos