Page 295 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

You can then apply any relevant data transformation steps on selected columns from the ribbon or certain steps
can be accessed with a right click on the column heading. Commands that are not available to your selected
column or Each column has a data type icon on the left hand of the column heading. You can left click on it to
change the data type of the column.

You can choose from decimal numbers, currency, whole numbers, percentages, date and time, dates, times, time
zone, duration, text, Boolean, and binary.
Using the Locale option allows you to set the data type format using the convention from different locations. For
example, if you wanted to display the date in the American m/d/yyyy format instead of the usual dd/mm/yyyy then
you could select United States as the locale.

There’s a small table icon in the top left hand corner of the data preview, you can right click or left click this to
access various actions that affect the whole table.
Renaming any column heading is really easy.

282

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77