Network Intent supports to add Formula Column to table variables, which converts the original variables into different formats or different values. For example, converting the short name of interface Ether1/1 into full name Ethernet1/1, or converting the IP address to the corresponding device hostname.

1.In the Define Variables tab in Network Intent edit mode, click Add Table or Add Paragraph to define table variables, then click All Variables.

2.In the pop-up window, click Add Formula Column.

3.Define the Name, Type, and Definition for the Formula Column. It is optional to set an initial value for Formula Column.

▪Name — Name can only contain letters, numbers, and underlines, and can only start with a letter or underline.

▪Type — The selection of the Type should be set according to the data type actually returned by compound variable or formula.

▪Definition — The Definition input supports two ways, one is mathematical operation, such as $var1 + $var2; the other is to call functions and see Appendix: Supported Functions in Network Intent for list of supported functions in Network Intent.

4.Click OK and the Formula Column is added as a new column to the table and marked with green color.