Hi
I am trying to create dropdown with dates provided in input file.
And I am to do that but the problem I am facing is that when I am using 2021 year file I am getting the dates which are present in file.
But when I am changing the input file and using next year in analytical app it is still reflecting the date from previous file.
How can we resolve this?
I am adding my workflow and last and this year files.
Please help in this 🙂
You uploaded the same excel file twice.
Have you tried to run the workflow from the desktop with the new file ? the problem is that the Dropdown list keep data in memory running the workflow twice could solve the issue.
Or I receommande you to use an input text instead of a drop down list.
Hope this helps!
Regards,
Hi @messi007
Yes sorry for uploading the same file I am adding new one here.
Yes I can run that from desktop but I need to migrate the workflow to server and users will run it from there so I cannot keep using desktop every time.
Yes I am aware about text input but this data may change so I want user to use the new file every time the run the workflow.
Is there no workaround for this?
The situation with dynamic input into an App and memory is solved by chaining applications together. The first application reads the file, writes a name/value file and then calls the second application. The second application reads Drop Down reads the name/value file and takes action. If you need additional ideas let me know.
https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120
or
I have done it using chained app. So thanks to @SoccerTil for the idea 🙂
1-
I created the first app that update the input for the dropdown list
2- Create the an app with only the drop down list (DropDown.yxwz)
3- I chained the first app with the second app
Now I can see the new dates:
Attached bith apps.
Hope this helps!
Regards