These updates include the following enhancements to the recently released "Add Column From Examples" feature, which can be accessed via "Add Column" tab on the Query Editor ribbon:
As users go into “Add Column From Examples” we will show suggestions for output values based on the contents of other columns and partial contents typed by the user. These suggestions also help disambiguate between multiple transformations where the output value might be the same for a given row.
Support for Additional Transformations
We added support for many additional transformations, including Number, Date, Time and Timezone operations. Here is the full list of transformations that we are currently supporting:
Reference — Reference to a specific column including trim, clean, and case transformations.
Combine (supports combination of literal strings and entire column values)