Sampling Workflow with Input from App

[DSchro]

Hi there!

I am currently trying to build a Alteryx app that helps me to pull samples from a population. Here are the key details:

The populations are within a folder, which is read by the workflow. Over the App I am telling the workflow, which Sheets needs to be read by the marco to get the populations of the single files into my workflow.

The populations look like this:

entity1.xlsx

Customer	Customer ID	Address Customer	Change Date
Customer 1	Customer ID 1	Address 1	01.01.2019

entity2.xlsx

Customer	Customer ID	Address Customer	Change Date	User ID
Customer 130	Customer ID 130	Address 130	01.01.2019	User ID1

Through the random sampling tool I pull a sample and write it to the "Sample_Output" Excel file. The Workflow looks like this:

When I start the app, the action boxes pops up and ask for the variables that need to be defined for the workflow to be run:

So my question at this point is, how can I display certain information of the population files in the app already. As the population differs in sizes, the size of my samples varies from workflow to workflow as well. So I will need the information, how many rows of data are actually in the population files as a sum.

Is that possible to have an output of the population size in the Designer so that I can decide, which sample size to choose?

I have attached the workflow below. Hopefully we can find a solution.

Thanks 😉

Daniel

[Blake · Accepted solution]

Hi @DSchro - You'll want to utilize a chained app to accomplish this. Here are some helpful links. 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Chained-Alteryx-Analytic-Applicatio...

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

Good luck!

[DSchro]

Hi Blake,

that's what I was looking for! Thank you very much! 😉

Daniel