I'm having issues with the Multi-Row Formula tool losing its Group By selections. We are using this to create unique IDs in our data so we can better match data together. When the settings are in place, everything is fine. But Alteryx keeps losing the Group By selections which makes the unique ID useless. Is there any way to make sure these settings stop being forgotten? We had a similar issue with setting field types with the Select tool and having Alteryx change all the data types if it finds a difference in the incoming data. We fixed this by doubling up the Select tool and locking the field types. Needed two Select tools because we weren't able to lock all the fields in first Select tool. I'm hoping something like that can be done here as well.
The workflow is rather large and makes several database calls, so I had to select "Disable Auto Configure" in Advanced settings in order to be able to work with the workflow. Without this, clicking from one tool to another would take up to 10 seconds. Could this be part of the issue?
It seems to be random as to when I'll lose the settings. The only thing I can think of is if it is losing the data source for some reason and without the data coming in from the previous tool, it just forgets the settings??
Any suggestions appreciated! I can't keep having it lose settings and causing data not to match.
-Winston
