Forum Discussion
Syndicate_Admin
4 years agoAdministrator
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...
- 4 years ago
VAR theCI = VALUE(VR_PBI_COMERCIANTES[CIIU1])
SWITCH(TRUE,theCI >= 0111 && theCI <= 0322, "Agropecuario",theCI >= 4511 && theCI <= 4799, "Comercio",....y mas
AlexisOlson
4 years agoSuper User
I think this should work if you change the "&" after 4911 to "&&".