Formula to put Tick Marks around values in a column?

Options
FarSideFeb
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
    Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
    Options

    Hi,

    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.

Setup Info
    Tags
      Help me…