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
HotChilli
4 years agoCommunity Champion
VAR theCI = VALUE(VR_PBI_COMERCIANTES[CIIU1])
SWITCH(TRUE,
theCI >= 0111 && theCI <= 0322, "Agropecuario",
theCI >= 4511 && theCI <= 4799, "Comercio",
....y mas