Error In Updating Query with Interface Tools

Question

Hi, I am trying to update a year in my query via a user input as part of an analytic app. The query is hard coded with the year 2021 for one input and 2022 for another so that it can be replaced with the number that is put into the user text box. However, when I put in 2024 and 2026 or something like that in the user box, I am getting the year changed to some random numbers as shown in the second image below. Why is this happening and how can I fix it? The numbers are treated as string in the query and I thought I had it working last night but when I checked back on it this morning it doesn't work so i guess I have had this problem all along. It seems as though the second set for month had no issues updating when I did this the same way.

Thank you

ChrisTX · Answer

I understand not being able to post a workflow due to confidentiality. But this may be one of those cases where it's almost impossible to help you without the actual workflow. My only suggestion would be: In your Input Data tool, you have a value of something like 2021 Manually change the "2021" to a test value, save the app, test the app with the Open Debug functionality, then run the workflow in the Debug window and see if you get any errors. Hoping others can chime in to help you. Chris

Link86 · Answer

@ChrisTX The tool before is a text input tool, the tool after is the green input tool. The data connections are saved and aliased. The workflow runs without issue if I do not run it as an analytic app.

This is the discussion that got me to where I am today. It worked when it was first implemented but I do not know why it is not working now. No other changes were made to this part.  https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-SQL-Query-with-Regex-to-replace-year/m-p/1024458#M253252

ChrisTX · Answer

It looks like you're trying to update a File Name (or a Connection pointer to a file).  Can you show the tools used before and after the Action tool?

The "aka" may be a connection pointer.  Does a pre-defined Connection exist, that matches the Connection name after you replace the Year number?

Chris