Hello All,
I'm trying to create an analytic app where user can enter data using the drop down tools and it will generate output file with all the details entered by the user. I've created a sample excel file and where I entered the header names that needs to entered by the user and connected with the input file but not sure why it's not populating data entered by the user in the output tool.
As this app will be used by many users, I want the entries to be added in the same excel(new row) without overwriting the previous entry.
Please advise. Here are some snapshots
Regards,
Swapnil
Solved! Go to Solution.
Hi @swapsingh2712 ,
You appear to have only attached the screenshots and not a sample of the data and the app itself. Can you attach these so we can help you?
Mock data is fine as long as it's representative of the real data.
M.
Hello mceleavey
Thank you for your response.
Actually there's no sample data. I'm trying to create an app where user can enter the data using the drop downs and it will output in excel format.
Here's the workflow which I've created and the input file which I've used.
Apologies if the workflow looks silly. I just started working on Alteryx
Swapnil
First change is the output option it needs to be set to append.
Let me look into the rest of the workflow.
Since input file has no rows data stream through will also be no rows.
Hope this helps : )
Hi @swapsingh2712 ,
Please find attached a sample workflow that does what you have described.
Hope this helps.
Best,
Jagdeesh
Bingo! See attached and below workflow.
If it works for you, please share, bookmark, 'Like' and/or 'Accept as Solution'
Here is what you can do if you want to add only one new row you can do something like below by directly using text input tool.
Workflow:
Edit: @HomesickSurfer has shown you possibility of capable options 🙂
Hope this helps : )
Hello JagdeeshN
Thank you for your response. This solution worked for me. I have few follow up questions. Hope you'd be able to help.
- Is it possible to add a feature where once the user enter records, he/she will be able to see the output in a dialog box before it generates an output file.
- How can I setup a condition like if the user enters all the drop down value same, it should pops up an error
Swapnil
Hello HomesickSurfer
Thank you for your response. This solution also helped me 🙂 . Hope you'd be able to help me with my follow up queries