I'm trying to create a history file using PREP on Server.
The history file needs only to contain the Task ID, the Task Status (which may change), and the Rundate.
Consider this SNIPPET of my file (on the left) as it changes over three days, and the reflection of the History File (on the right).
When the STATUS of an ID changes (or a new ID is added to the file), the History File grows.
The challenge I'm facing currently is PREP cannot make changes to a table that is currently being used.
Is the best option to create two history files... History File A generates History File B, and then a separate flow rewrites History B over History A?
Thanks for your feedback & creativity!
Michael Hesser (Tableau Forum Ambassador)
If this response has answered your question, kindly click "Best Answer"
@Don Wise Many thanks-- this is pretty much where I was before, but yours is more streamlined.
Creating the ID is going to be troublesome because I have dozens and dozens of fields, making a concatenation a headache-- but doable,
I think this will need to be a two-step process.
Step 1: Merges CURRENT with HISTORY file, outputting to MODIFIED HISTORY.
Step 2 (another flow): Rename MODIFIED HISTORY to HISTORY. This should resolve the chicken/egg issue, but means a second flow needs to be kicked off.
Again, thank you for your help!
Michael Hesser (Tableau Forum Ambassador)
If this response has answered your question, kindly click "Best Answer"
