Forum Discussion
Solved
Create column based on text-like data
Hello Community I need to create a column based on an international encoding called ISIC that goes something like this: CIIU 0990 1850 0114 3311 4560 I'm creating the column with the follo...
VAR theCI = VALUE(VR_PBI_COMERCIANTES[CIIU1])
SWITCH(TRUE,theCI >= 0111 && theCI <= 0322, "Agropecuario",theCI >= 4511 && theCI <= 4799, "Comercio",....y mas
Create a variable using VALUE(theField) and use that in the comparisons.
It means less typing too.
The last line of the switch is using a different field. Correct?
I don't quite understand your answer, could you please explain a little more?
