Please have a look at this link for doing unions
This is a new feature in tableau 9.3.
Will the actual data be reporting on these snapshots or will there be a live connection.
If it will be reporting on snapshots you just need a data refresh at the times the snapshot is created and files are over written
Thanks for your quick response. I tried the union function and it looks like that will solve my problem. The only problem is that the jan-april and april-may file have date formats in yy-mmm and is recognized by tableau as a string. I have no problem with the 2013-2015 historic data. When i do the union i get nulls for the date periods in 2016.
Any tips in dealing with this will be appreciated. Thank you
Is it not possible to change these prior to loading.
This would be ok if this is a one off issue and the data format is locked down for ongoing data files