I've got a baseball team and I'd like to create an app where each player can select their number and then select from a number of drop downs to rate themselves on different game skills(Low/Med/High). Once completed, the data is time stamped and saved. I do not want the player to be able to see other player ratings when finished, but seeing his own entries is okay. The end goal here is to have this player list with each of the skills list populated with what the player entered and ready for analyzing to see who should be promoted to the next league. (There will be a part B where the coach will be able to enter in data for each of his players, but really, baby steps.)
I stopped when I kept running into challenges with the Find Replace tool...
I'm at a loss here. Is this even possible? Sample data below. I entered in the "Unknown" as a place holder thinking I'd use Find Replace, but I'm not having luck with that. Can basically pull out the player and add the time stamp, but entering and saving the skills I'm at a loss...
Employee ID | Position | Employee MGR | Promotion Date | Date Reviewed | Game Knowledge | Attitude | Mentor Skills | Readiness |
M1 | Pitcher | M8 | 02/10/2016 | Unknown | Unknown | Unknown | Unknown | |
M2 | Pitcher | M8 | 01/02/2016 | Unknown | Unknown | Unknown | Unknown | |
M3 | Catcher | M9 | 07/11/2017 | Unknown | Unknown | Unknown | Unknown | |
M4 | Catcher | M9 | 08/19/2014 | Unknown | Unknown | Unknown | Unknown | |
M5 | Outfield | M10 | 11/18/2014 | Unknown | Unknown | Unknown | Unknown | |
M6 | Outfield | M10 | 08/19/2014 | Unknown | Unknown | Unknown | Unknown | |
M7 | Outfield | M10 | 04/28/2017 | Unknown | Unknown | Unknown | Unknown | |
M8 | Pitching Coach | M11 | 08/19/2014 | Unknown | Unknown | Unknown | Unknown | |
M9 | Catching Coach | M11 | 11/13/2017 | Unknown | Unknown | Unknown | Unknown | |
M10 | Outfield Coach | M11 | 08/19/2014 | Unknown | Unknown | Unknown | Unknown | |
M11 | Manager | M11 | 08/19/2014 | Unknown | Unknown | Unknown | Unknown |
How about instead of using a Find Replace tool, create a new record for each update with a "Date_Modified" field and only displaying the most recent update? This system could also support a "User_Type" flag to identify player vs coach updates.
I've updated the original workflow. I realized that I cannot append to a .yxdb So instead of trying to use a single file to update, I switched the file types to Excel and switched to separate source file and an output file-which appends the player results to the current file. I welcome thoughts to address differently.
The user input functionality I wasn't too confident on getting a solution, so I appended the choices(Low/Med/High) into the file and then created filters for the user to select their options. Again, I welcome thoughts to address differently.
You could accomplish appending to an Alteryx database by using an intermediary database. In your workflow, ingest the existing output database as a step, union that database with your player data, and then output to the existing output database. You will likely need to use some blocking to ensure the file is not open when you are trying to write to it.