In my experience doing data transformations in Tableau is almost always a mistake. It's opaque what's actually happening and you can't version control the actual operations. Instead, preprocess data into a view in your database or with a script and read that into Tableau.