i have two calucated columns and wanted to union the both the columns in sap datasphere

In SAP Datasphere, if you want to create a union of two calculated columns, you will typically leverage SQL or the graphical modeling capabilities provided in the platform. Here’s a step-by-step approach to accomplish this:

### Using SQL:

1. **Create a Calculation View**:
   - Go to the modeling area of SAP Datasphere.
   - Create a new Calculation View (or open an existing one).

2. **Define the Calculated Columns**:
   - If you haven’t done so already, create the two calculated columns within your Calculation View.

3. **Use SQL to Union**:
   - You can write a SQL script to create a union of these two columns. Here's a basic example:
   
   ```sql
   SELECT YourColumn1 AS CombinedColumn
   FROM YourTable
   UNION ALL
   SELECT YourColumn2
   FROM YourTable
   ```

   Replace `YourColumn1` and `YourColumn2` with the names of your calculated columns, and `YourTable` with the actual table/view where these columns are located.

### Using Graphical Modeling:

1. **Create a New Calculation View**:
   - In the modeling environment, start a new Calculation View of type “Union”.

2. **Add Data Sources**:
   - Drag and drop your previously created Calculation Views (that have your calculated columns) into the union node.

3. **Configure the Union**:
   - Ensure that you match the data types for the columns you want to include in the union. You may need to rename output columns to ensure they are consistent across both sources.

4. **Save and Activate**:
   - Save your Calculation View and activate it to make your union available for use.

### Final Steps:
- Test your union by running queries against the new Calculation View you've created to ensure that the combined data looks correct.
- You can also apply additional filters or transformations after the union if further processing is required.

### Note:
- Make sure that both columns being unioned have the same data type, as unions require compatible types across all selected columns.
- If you want to remove duplicates, use `UNION` instead of `UNION ALL`, as the latter retains duplicate records.

This process will help you combine the data from both calculated columns effectively within SAP Datasphere.