The String Left node is used to include only a substring consisting of a given number of characters from a string column, moving from left to right. This is useful if the string contains a prefix that is private or not relevant for end-users for instance.
Take the Left String
Start by connecting the String Left node to the Select node of the relevant table. Go to the Properties panel to define the substring:
Select Column: choose the relevant column from the drop down.
Characters to Take: enter the number of characters to be included in the substring, from left to right.
Column Output: decide whether or not to keep the original column.
New Column Name: name the new column.
Example. Take the Left Substring
In this example, the first 11 characters in the string are taken:
