Add column from example

  • The Column From Examples feature allows users to simply type an example of a desired column rather than apply the necessary transformations
  • The engine determines which M functions and series of steps to add to the query that return results consistent with the examples provided
Figure 115: Column from Examples UI
  • In the following example, the sample value of Jon is provided and only the Customer Name column is evaluated for possible transformations
Figure 116: Sample Value Entry for Add Column From Example
  • The engine determined, based on the example, that the Text.BeforeDelimiter() function was appropriate