textFormat function in the Factory

The textFormat function returns the type of the strings in each row of the column.

Parameters

textFormat(column)

Parameter

Description

column

The attribute from which we want to retrieve the type of each string. Its type must be nominal. The column parameter is mandatory.

Example

The following example uses the Bike Sales dataset.

Description

Screenshot

In this example, we have manually updated certain values within the Age Group attribute. We have added:

  • 35 in row 3;

  • 64 in row 4;

  • 100% in row 6;

  • 5.4 in row 10.

Rename the Var_19 attribute to textFormat, then type the following formula: textFormat($"Age_Group")

As you can see, the function has returned ‘nominal’ for all the values except:

  • row 3, which is ‘integer’

  • row 4, which is ‘integer’

  • row 6, which is ‘percentage’

  • row 10, which is ‘continuous’

Search