# Supported Data Types & Column Header Functions ## Supported Data Types Phiona automatically detects the following datatypes. While a majority of datatypes are treated as text values, certain values are treated as numbers or dates (noted below). * Text * Numbers * Boolean Values (Yes/No, etc) * Dates and Date/Time (treated as dates) * Currencies (support $, €, £, and ¥, treated as numbers) * Email Addresses * URLs * US State Abbreviations * US Zip Codes * International Phone Numbers * US Social Security Numbers * Credit Card Numbers ## Column Header Functions When clicking on a column header in a data, a dropdown menu will appear allowing you to select certain smaller datagrid view, transformation and filtering functions. ![Example dropdown menu](/files/-MfZU34HRcofUvB5TT4r) ### Number Columns #### Dragging or Resizing the Column Resize the column to a different size by hovering on the right of the header (a blue line will appear) and dragging left or right, or move the column to another part of the spreadsheet by selecting the column header and dragging it to the desired position. #### Rename Column Renames column to another header name. #### Filter Column Filter numbers to only the ones that are required in the dataset. For example: if you are looking to filter for the value "8", selecting Equals Value will show only numbers that are EXACTLY 8, whereas selecting Contains Value will show any number that includes an 8 in it, like "18" or "82". ***Supported Operations:** Contains Value, Does Not Contain Value, Equals Value, Greater Than Value, Less Than Value, Not Equal To Value* #### Transform Options Performs mathematical transformations on each cell. ***Supported Operations:** Add Commas, Convert to Percentage, Remove Commas, Remove Decimal Points, Set to 2 Decimal Places, Set to 3 Decimal Places, Set to 4 Decimal Places* #### Sort Column Sorts the numbers from the lowest value to the highest value or vice versa. #### Display Options Allows you to size the column automatically depending on the length of the data in the cells, or freeze the column in place so that you can scroll to the right while always seeing the data in this column. ***Supported Operations:** Autosize Column, Pin Column* #### Column Options Perform actions on the column itself, like duplicating it, or adding a blank column to the left or right of the selected column. {% hint style="info" %} Please note: deleting a column does not delete the raw data from the data source that was connected to Phiona! {% endhint %} ***Supported Operations:** Add Column Left, Add Column Right, Delete Column, Duplicate Column* ### Text Columns #### Dragging or Resizing the Column Resize the column to a different size by hovering on the right of the header (a blue line will appear) and dragging left or right, or move the column to another part of the spreadsheet by selecting the column header and dragging it to the desired position. #### Rename Column Renames column to another header name. #### Filter Column Filter text to an exact match or containing match. For example, if you're filtering for the value "male", an exact match would bring up all of the exact "male" results while containing would also include "female" results as well. ***Supported Operations:** Contains Value, Does Not Contain Value, Equals Value, Not Equal To Value* #### Transform Options Performs text transformation on the values. ***Supported Operations:** Capitalize, Lowercase, Trim Surrounding White Spaces, Trim White Spaces, Uppercase* #### Sort Column Sorts the numbers from the lowest value to the highest value or vice versa. #### Display Options Allows you to size the column automatically depending on the length of the data in the cells, or freeze the column in place so that you can scroll to the right while always seeing the data in this column. ***Supported Operations:** Autosize Column, Pin Column* #### Column Options Perform actions on the column itself, like duplicating it, or adding a blank column to the left or right of the selected column. {% hint style="info" %} Please note: deleting a column does not delete the raw data from the data source that was connected to Phiona! {% endhint %} ***Supported Operations:** Add Column Left, Add Column Right, Delete Column, Duplicate Column* ### Date Columns #### Dragging or Resizing the Column Resize the column to a different size by hovering on the right of the header (a blue line will appear) and dragging left or right, or move the column to another part of the spreadsheet by selecting the column header and dragging it to the desired position. #### Rename Column Renames column to another header name. #### Filter Column Filter text to an exact match or containing match. For example, if you're filtering for the value "2019", an exact match would bring up all of the exact "2019" results while containing would also include "01012019" results as well. Phiona also supports exact date filtering, as well as relative data filtering compared to the current date. ***Supported Operations:** Contains Value, Does Not Contain Value, Equals Value, Not Equal To Value, After, Before, Day, Equals, Month, Range, Specific, Today, Week, Year, Yesterday* #### Sort Column Sorts the numbers from the lowest value to the highest value or vice versa. #### Display Options Allows you to size the column automatically depending on the length of the data in the cells, or freeze the column in place so that you can scroll to the right while always seeing the data in this column. ***Supported Operations:** Autosize Column, Pin Column* #### Column Options Perform actions on the column itself, like duplicating it, or adding a blank column to the left or right of the selected column. {% hint style="info" %} Please note: deleting a column does not delete the raw data from the data source that was connected to Phiona! {% endhint %} ***Supported Operations:** Add Column Left, Add Column Right, Delete Column, Duplicate Column* --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.phiona.com/transformations/supported-data-types-and-column-header-functions.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.