Analytical app

stj1120

Hi all,

I need to develop one Alteryx app for the business purpose. 

Scenario: We have 4 different data sources. We are merging the data among these four data sources and checking where the stock is present in which data source. If the stock quantity is present then we mark it as Yes else No. 

So, user needs this report after he enters the list of materials ( either 20 / 50 / 100  / 500 etc) in the text box or any other analytical app tool that he needed to look during that time. Once he enters then these materials should be searched (filtered) in the final output of the Material number column and once he clicks on Run button then accordingly the workflow must run at the backend and generate the excel with the desired output. 

Output format is already designed in the workflow. Only thing we needed is the analytical app. 

Kindly help me by creating the analytical app using the attached workflow as said above. 

Please check the attached workflow. 

Thank you.

Best regards,

STJ

item action.yxmd

15.xlsx

be.yxdb

04.yxdb

03.xlsx

abe_ibanez

Hello, 
What is the unique identifier for the part number? Is it TIN? 

For example, 7201163 is associated with two different components in 03.xlsx, but only in 04.yxdb is associated with NOVOLOG FP 5X3ML RELION. 

Also, which column in each of the 4 inputs indicates the actual available quantity? Seems like the naming is different across the different files. 

I think the best way to approach this issue is to join the four inputs into a single data stream. Once you do that, you can bring in the user's input into a text input tool. You can then use that to filter against the cleaned list you have. 
So it could be something like this: