Thanks Tim, this was really useful! Did you end up creating an example dataset/video based on the support tickets use case you mentioned at the end of the video?
I reached to your video because I'm searching a way to calculate the difference in sequential dates in one date field in Tableau Prep. I'm able to do it in Tableau Desktop with a Lookup but I'm searching a way to do the same in Tableau Prep.
This was very helpful. I have been searching for a way to solve blank date columns in Tableau workbooks. On a date field, in the row fill step, is there a way to set the end value to today? I created a calculated field of DATE(TODAY()) hoping I could input that in the Max box but it doesn't seem to like that approach.
@@TableauTim I am so glad you replied! My max date on the field I am filling off of is prior to today so I'm trying to create rows for future dates through the current date.
They need to optimize the loading speed for new rows especially when you are connecting to tables in servers. Painful experience waiting for the new rows step to finish loading before I can configure. And when you have a datasource with multiple date fields and you want to fill up all of them, seems like placing multiple new rows will cause the flow to fail.
Yeah good point. I’ve had mixed experiences. On fast well optimised databases (snowflake as an example) this has been as fast as using a local file. There might be some optimisations at a database and your local infrastructure they can’t get round. You can test this by installing a database on your laptop and seeing how fast it is in that instance. That should give you a baseline of what to expect.