ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

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

 

3 REPLIES 3
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

 

alexnajm
19 - Altair
19 - Altair

@elclark following up after PTO - what's the status on this?

Labels
Top Solution Authors