Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Generating rows - issue

mikaelhyensjo
7 - Meteor

Hi. 

 

I have created a simple workflow which should generate rows from arrival date to departure date. 

 

Using the generate rows - but get error "Error: Generate Rows (4): Cannot add 1 "days" to "9999-12-31": Invalid Format Parameter, or Year out of Range.

 

Both my Arrival and Departure dates are dates.

 

Regards Mikael

4 REPLIES 4
jdunkerley79
ACE Emeritus
ACE Emeritus

Could you post some screenshots of what you have for the generate rows and some sample data?

 

Sample attached generating a set of dates for reference

mikaelhyensjo
7 - Meteor

Hi. 

 

I sending one excel file with only one row and my workflow.

 

Thanks 

 

Mikael

jdunkerley79
ACE Emeritus
ACE Emeritus

Take a look at the attached.

 

The set up for Generate Rows is:

2016-12-16_11-36-16.png

mikaelhyensjo
7 - Meteor

Thanks.

 

I see what I did wrong.

 

Mikael

Labels