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.
thank you HomesickSurfer
This is helpful :). Also is there any way we can preview the entire output file (data entry_master.xlsx) in alteryx?
Trusting that this meets your requirements. Please confirm or advise. If so, please share, like and/or accept as solution. Thank you
Hello HomesickSurfer
Quick question regarding the workflow as I was unable to extract the files.
Do I need to create new columns ID2, ID3 and ID4 in the master - Data Entry excel file?
Swapnil
No need to create. You should be able to open and export the package. Save it locally, then double-click on it. It will open with Designer.
Hello HomesickSurfer
I was able to fig out my last query. Just quick question, while running these workflows I see that It's creating 2 ID columns. Is there any way I can remove these fields from the out put file
Screenshot attached.
Swapnil
I've modified the workflows in the attached workflow group by removing the ID creation in the View Data Entry and also added an incremental ID process in the Data Entry flow. All good now.
Hello HomesickSurfer
Thank you for all the help. Just wanted to ask you, regarding the delete data entry workflow, is it possible that instead of deleting the record, we can update the existing record. for example all the values are same, we just want to update the head count based on the record id. I tried updating it but it didn't work.
Swapnil