Issue in replicating alphanumeric from one column to another
deep_215
Registered Posts: 12 ✭✭✭✭
I am trying to create a column COL1 replica of COL2 using prepare recipe (formula). COL2 datatype is string and values are numeric/alphanumeric. I observed wherever data ends with "F" it replace it with ".0", however it works as expected for other value. Below is the sample
COL1 | COL2 |
|---|---|
113816A | 113816A |
113816 | 113816 |
113816F | 113816.0 |
Request you to please provide a solution to it.
Operating system used: windows
Operating system used: windows
Best Answer
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,501 NeuronYou should use:
strval("COL1")
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,501 Neuron
What formula are you using?