A union in Tableau is best used when you have two or more tables with similarly named columns that you want to combine by stacking them vertically (adding rows). This is useful when you have separate tables with the same structure (e.g., monthly sales data in different files) and want to consolidate them into one table. Options involving distinct values, differently named columns, or different formats do not directly align with the purpose of a union.