I found solution...is not the most elegant one but it does the work.
If someone will have similar problem may make it better then this one and share:)
Thank you very much! :)
I will take a look and check this one.
I was trying to create new table with dates and first value for the date and then replace nulls with those values but it didn't work.
two peas in a pod, these two...
Thanks @MarqueeCrew for taking the time to recognize @SeanAdams! It's awesome to see both of you working together to help our members make the most of the Alteryx product suite. Keep up the great work!
Thank you Mark - as we discussed, there's a lot to learn from you and the other more seasoned members of the community, so I have a long road ahead.
Would you have an example of what you are trying to build and an example of error message if any?
I have attached a really basic example but I am not sure if this is the kind of thing you are trying to build.
Customer Support Engineer
In order to complete this you will need to chain some applications together. I have included packaged up an example app using Alteryx v11.
Firstly you will need to produce an app that will enable a user to enter some address information. This will need to end up with producing a separate file with the list of buildings that meet the criteria as a .yxdb. This can then be read and used as a list box within Alteryx. It is important that you have columns named 'NAME' & 'VALUE' in order for this to work. In the Interface Designer you will need to select the 2nd app to run on success.
The 2nd app will need to have a list box tool. Within this tool an external data source can be selected. This should be linked to the output from the first app.
Please see the packaged app below. I have applied very basic criteria for searching addresses so I advice searching for 'London City' when running the app.
Hi @patrick_mcauliffe, this can be achieved by using the AlteryxService.exe command line interface to run these workflows. The addtoqueue command will schedule a workflow for immediate execution by placing the job into the execution queue on your controller. You won't need to designate whether the workflow is run on the Controller or a Worker as the Controller will handle the queuing of the jobs which are then automatically picked up by the next available worker. This behavior is a lot like when a workflow has been scheduled to run using the Alteryx Scheduler. Here's a link to a Community post on the Server command line that you might find helpful: https://community.alteryx.com/t5/Engine-Works-Blog
I've used the solution that Alex suggested many times, however, in one case I had to work with millions of rows and the joins really slowed things down.
I found an alternative solution by using the Sort and Sample tools.
In the example, I sorted the Date field in Descending order and then use the Sample tool, choosing the First N Records (N = 1) and Group by Pass and Code.
Depending on the size of the dataset and the tools you feel more comfortable with using, you can consider this option as well.