- Navigate to the Repository Explorer
- Click on Create - Data Flow button to create a new view
- Click on Details button and configure the following properties:
- Business Name: DF_EMPLOYEES
- Technical Name: DF_EMPLOYEES
-
Drag and Drop the table CSV_EMPLOYEES into the canvas and set the type to Source.
-
Add a new Script Operator from the menu. The name is defaulted to Script 1.
-
Select the source operator CSV_EMPLOYEES and add a new Link to the operator Script 1.
-
Select the operator Script 1 and create a new column from the menu.
-
Maintain the properties as the following and click on Save button.
- Name: FULL_NAME
- Data Type: string
- Length: 30
-
Click on the Edit button.
-
Insert the following script.
##################################################### # Provide the function body for data transformation # ##################################################### data["FULL_NAME"] = (data["NAME_FIRST"] + ' ' + data["NAME_LAST"]) return data
-
Add a new Table from the menu.
-
Select the operator Script 1 and add a Link to the table.
-
Select the operator table and maintain the following properties
- Business Name: T_EMPLOYEES
- Technical Name: T_EMPLOYEES
and click on the Create and Deploy Table button.
-
After the table T_EMPLOYEES is created, change the update mode to TRUNCATE. This mode will delete all the data of the table before running the data flow. The other possible mode is APPEND, which will keep all the data.
-
Click on Save and Deploy button.
-
Click on Run button to run the data flow. Make sure that the process is completed by click on the Refresh button.
-
Select the target table operator and click on Preview Data from the context menu. Validate the result of the column FULL_NAME.
