Unable to create dynamic chained app

avinashlearn

I tried creating a dynamic chain app which first takes data from customer and order table using my SQL server. Then firstly it filters on CustomerCategoryID then the output is stored in a yxdb file. Then in 2nd App that output should be picked and then using drop down filter it should filter on CustomerName. But the issue I am getting is the 2nd App is giving stale data of previous runs, that the customer names are not getting dynamically updated after App1 run.

The first App is Customer Category App and the 2nd is Customer Name App. At the end I have also added the drive link for video I have captured while running the app in a chained manner but the last output block is empty because I have selected if there is no output then suppress it.

https://drive.google.com/file/d/1VHibRbp1zsc7c_z-k2Rqb3IGaF4zGH-U/view?usp=sharing

Customer Category App.yxwz

customer_Dataset.xlsx

Orders_Dataset.xlsx

Customer Name App.yxwz

davidskaife

Hi @avinashlearn 

Please find attached updated Apps for you. I'll outline what i've done below:

Customer Category App - created an additional output which contains the Customer Name data in NAME:VALUE format which can be used to feed into the second app. This output has been saved as a YXDB file.

Customer Name App - You use the YXDB created in App 1 to feed the data into the Drop Down Tool and set it to read in from an External Source

This means you can remove majority of the tools from App 2, and add in the Action tool as previously advised. I've also changed your Excel output option to Overwrite File (you may want to change depending on what you want to happen)

This seems to now be working!

Side Note: I've changed the output file paths to "./filename" which basically outputs the files to the same folder that the app/workflow is located, you'll need to update these back to your filepaths!

Customer Category App.yxwz

Customer Name App.yxwz