In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Generate Rows incorrectly changing unrelated fields

elclark
8 - Asteroid

Hello,

I have a table that has City, State, Start Date, and End Date. I'm using the Generate Row tool to generate a row for each date between the start date and end date. However, what I'm finding is that it's changing the City names, so even though the original row said Los Angeles, some of the new rows will say LosAngeles (removing the space) or Los  Angeles (adding an extra space). Here is how my Generate Rows tool is set up. How do I fix it so it's not changing any fields and just adding the dates.

 

elclark_0-1764176552644.png

 

2 REPLIES 2
alexnajm
19 - Altair
19 - Altair

This should not happen - can you show us this behavior? Or better yet, include the workflow with some sample dummy data?

jrlindem
12 - Quasar

Agree with @alexnajm, this should not be happening...  I set up a quick experiment, and my results were as expected, meaning the Generate Rows Tool did not impact the CITY field that it was not configured to affect:

jrlindem_0-1764601873178.png

@elclark did you get this figured out or can you attach the workflow with sample data?  -Jay

 

Labels
Top Solution Authors