- Since the
LEFTfunction matches based on fixed numeric values, changes to the length or structure of a data field can cause your recipe to fail to properly execute.
LEFTfunction requires an integer value for the number of characters to match. If you need to match strings using patterns, you should use the
STARTSWITHtransform instead. See STARTSWITH Function.
Column reference example: