To apply a nested transform to a column on ingress to the platform:
- Navigate to your dataset, Click "edit".
- Select Review Data
- From the column header menu and select "Data Transforms."
- Edit the transform. In this example, the date column is conerted to a floating timestamp column using a transform..
- Select the run command and validate the results by examining the right column.
- Since the example data is not clean (has text, numbers, and invalid date values), we can ignore those errors by adding forgive function to the existing transform. This is the nested part of this transform.
- Run to confirm there are no more errors!
Comments
Article is closed for comments.