Formula to put Tick Marks around values in a column?
FarSideFeb
Registered Posts: 16 ✭✭✭
Is there a way to put tick marks around the values in a column? I have tried numerous ways, and cannot get a formula to work that puts tick marks around every value in a column.
I need ticks around the values to make the Dynamic Input tool work.
For example, I have the column, "OrderNo", and I want the values to have a single tick in the front and in the back: '12345'
Operating system used: Windows
Tagged:
Answers
-
Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 DataikerHi,
There are various ways this can be achieved.Among them, one of the most straightforward and flexible options is to use the formula processor in a Prepare recipe.
In here, do a concat of single quotes around your column value. For example, see Capture.PNG. In my example I put the output to another column, but it can be done in-place too.