Analytical app
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
![](/skins/images/6D1A0C9EBA6135D6305D0847479F5349/responsive_peak/images/icon_anonymous_message.png)