I have done something similar many years ago and so I'll state that use case and you may be able to get something from it. This solution was webpages embedded in Tableau, but could be just a gallery app, or a webpage anywhere else. It requires Alteryx Server, but a similar thing could work on Designer, with manual runs...
Issue:
- Stores had to submit rosters weekly for absorption into the system. Previously these were emailed and so not used programmatically. (I don't think Excel would be the solution these days).
End user interface (these were store managers around the country):
- We set up a template Excel roster format and distributed that to the stores.
- Embedded webpage in Tableau to submit the rosters.
Back-end:
- When the file is selected in the webpage and "Validate" or "Submit" is pressed, the webpage calls an Alteryx App via API.
- That Alteryx App would transform the roster into cells and use REGEX to validate each cell and make sure it was a valid item.
- The file was returned with information about the incorrect cells if it failed, otherwise it was transformed and loaded into the DW.
- By memory, I think we had 16 different REGEX formulas to validate that covered all the different formats required, and so it was basically just a matter of running the right validation against the field.
- Validation app may have been separate to the submission app, and the webpage only show "Submit" after validate returns a positive response... I don't remember exactly.
