Recipe/Data Prep Returns 0 rows: Dataset #1 has one row with a start date and end date. I have a recipe that joins (left join) Dataset #1 to a dataset of dates (Calendar). It joins on a join key of "1" in both datasets. The idea is to get a row of each date from the calendar for each row in Dataset 1. Then I will do a date diff calculation based on a start and end date and filter out those outside of the range. In effect I want one row for each day between the start date and end date.
The recipe looks good to me and the previewed data is as expected, with the output showing 34310 rows. When I run the recipe though, I get 0 rows in my new dataset. Why would the preview and the actual dataset be different? Any suggestions?
1 commento
I'm just gonna say something that is a mistake i'd have made. when fixing and rerunning recipes the name of the dataset may have been changed. and now instead of the new dataset you've fixed you may be looking for the old one with the mistake.(once a dataset is created I dont think it goes away without we manually delete it , changes in the recipe doesnt delete a dataset)
