I am taking one column which contains values that vary in length from 18 - 32 digits, and putting a single tick mark at the beginning of the number, and at the end of the number.
After typing out my formula concat("'",OrderNBR,"'") my new column, "OrderNBR2", contains truncated order numbers. The original OrderNBR column has the data type of string - text, and is not truncated. IS there a way I can put a "cast" or some other feature into my concat formula to prevent the order numbers from truncating?
There are a number of ways to deal with these challenges. Regarding the idea of using a Cast statement, One can create recipes using many different tools, partly depending on where your data is stored.
Is your data stored in a SQL database? You might try a SQL recipe and do the computing in the database. In that case, a CAST statement is available to you. Are you comfortable with Python (or even R) you can create recipes in your flow that use all of the power of those languages?