Column Referencing

Column referencing is the process of identifying and accessing specific columns from a data source or table.

You can reference a column in three ways:

• table_name.column_name

  In this example, the traditional SQL convention of referencing a column is followed ( CUSTOMERS.CUST_ID).

• table_name[column_name]

  Data Augmentation Scripts supports a list of columns so a single column can also be referred to as CUSTOMERS[CUST_ID].

• THIS.column_name
  The keyword THIS refers to the current target table.

  THIS[ID, FIRST_NAME,LAST_NAME] = CUSTOMERS[CUST_ID,FIRST_NAME,LAST_NAME];
  THIS[FULL_NAME] = CONCAT_WS(‘_’,THIS.FIRST_NAME,THIS.LAST_NAME,THIS.ID) - DATATYPE VARCHAR2(18);
  
  //Instead of repeating the concat_ws logic
  THIS[NEW_ID] = UPPER(CONCAT_WS(‘_’,THIS.FIRST_NAME,THIS.LAST_NAME,THIS.ID));
  
  //we can refer the FULL_NAME using THIS
  THIS[NEW_ID] = UPPER(THIS.FULL_NAME);