I'm trying to full join two datasets based on range of dates, and given this I want to generate rows to dataset A. Though when I try to do this, the result is one row only (see screen shots). Any idea why this happens and how to fix it?
Try the config from the Generate Rows in the attached work flow
This gives
Dan
@iaa1
Since your date input is already in Alteryx format, you can you use DateTimeTrim() to convert to just hours
DateTimeTrim([start_planned],"hours")
See the attached with your sample input
Hi @iaa1
In Generate Rows, you've defined start_join field as a date and you're trying to add hours to it. Any hour information gets truncated in Date fields so the value never changes. Change the type to DateTime
Hi Dan,
I've tried al three date/time types, but none of them seem to fix my problem
