We implemented an ERP at the beginning of '16 so we have set up an ODBC connection to it and it pulls in fine to Tableau.
However, we would like to pull in 2015's data (from an Excel file) so we do not have to deal with having everything in Excel anymore.
However, the ERP system does not have the 2015 year in the Date(Year) pill. Is it possible to blend the data so it creates a continuous year between the 2 data sets?
So if I pull over the Date pill, it will create 3 columns (15/16/17) ?
Thanks!
Now that I look at it, is it even possible to have a union to a live ODBC connection?
When clicking on the other data sources (excel files), the "create union" link appears but not when I highlight the ODBC.
Would it be possible just to insert the union SQL into the custom SQL query that is pulling from the ERP system? I've never done it before so I'm not sure if it is possible
