Create a 2 parameters and pass them in custom sql
parameter 1 : A,B,C,D,E
Parameter 2: AA,BB,CC,DD,EE
write custom sql like this
Select Col1,Col2,Col3,Col4,<Parameter.parameter1> As Col5, <Parameter.parameter2> AS Col6,Col7,Col8,Col8 from ( Select * from table1)
Hope this helps kindly mark this answer as complete and helpful so that it will help others
i don't think we can do this. because each from clause has different join conditions. that is what my worry.
The viability of this will depend on how quickly your data changes and how much of it there is, but it is worth suggesting....
You could try pre-selecting the earliest conceivable start date and the latest conceivable end date a user may have and hardcode these into the SQL. You could then create an extract and just use the parameters within Tableau (i.e. do not pass them to DB via custom SQL). If your data allows you to do this, this should help tremendously with performance.