Define aliases and export formats
When you query data from a table, the queried data will have the column names of the table as headers. Sometimes, the column names are vague in describing the meaning of the data. In such situations, we can use an alias for the column. For example, you might want the data format (DDMMYY) of the column to be changed to a different format (MMDDYY).
This feature allows you to define alias and export format for output headers. The export formats can be defined only for the following data types:
- Decimal
- Time
- DateTime
- Date
Follow the below steps to define alias and export formats:
- On the Create segment screen, go to Output headers accordion.
- Click Define aliases and export formats.
- Enter an alias name for the header you want to change. If it is left as blank then the default output header will be exported.
-
To change the export format of the header, select the required format value from the Export format drop-down.
-
Click Save.
When the segment gets executed, you can notice the data will have defined aliases and the selected export format.
Updated 4 months ago