Column from Examples
Let’s use the Column from examples function to build a new column containing the item code and a shortened item description.
Select the StockItems query
Hold down CTRL to select the StockItemID and StockItemName columns.
Go to the Add Column tab and click From Selection from the Column from Examples drop-down.
In the first row of Column1, type the first StockItemID, followed by a space and then the first part of the StockItemName.
For example, the row 1 value looks like this: { 1 USB missile launcher }
Hit Enter then repeat this on row 2: { 1 USB rocket launcher }
And for row 3 enter: { 3 Office cube periscope }
Notice how the two columns are being concatenated into the new column all the way down, based on the examples you typed.
The description is also being trimmed of the item colour text.Click OK to complete the new column, then right click the new Custom column heading and rename as ItemIdShortName.
Examine the new column and note how the transformation has been applied to every row.
Now click on the ‘cog’ beside the Added Custom Column step to see the code that was created in the Column from examples function:
Note the complex code that was automatically created to achieve the creation of your new column:
Click OKTo apply this change, go to Home or File tab > Hit Close & Apply.
Save your work.