Rowcode in lookup tables

[aortiz_dd]

Hello,

Rowcode values must be only 10 digits as max?

We are working with lookup tables and I think We have a limitation associated with the number of digits in the rowcode which makes the syntax not working. But I’m not sure at all.

In the survey the idea is to ask for the unique registration number of the producers in the National Fruit and Vegetable Registry. These numbers are unique for each producer and have 12 digits, some can start with the value 0, that’s why it is entered as a string variable and then converted to numeric one and that is the rowcode value that is searched in the table.

First we want to verify that the entered registration number exists and if it does not exist, a Warnig is activated.

Secondly, we want to associate surface data and number of fruit plants declared by that registration number with the surface entered in the survey, if there is a coincidence of surface areas, the idea is not to ask the number of plants because this is a data already available, only if they do not match the plants will be ask.

[arthurshaw2002]

The development team might know better on this one. Numbers might have a different storage type in C# after a certain number of digits, and that might cause a problem.

Meanwhile, see the maximum size limit here, which you may have already encountered.

[aortiz_dd]

Thank you for your answer!!
We wait for development team´s response.

[sergiy]

See here:

Large Categories

When you send your interviewer to a particular respondent, preload the assignment with the particular village information obtained from the previous round. Do not store any confidential data in the questionnaire itself! This includes, for example: respondents’ data (such as names, ages, number of children, etc); interviewers’ data (such as name, interviewer ID, etc). Best, Sergiy

[aortiz_dd]

Thank you Sergiy.
About my specific question:
“Rowcode values must be only 10 digits as max?”
It is not clear for me yet.

In other side, If there is a limit of 10 digits, that limit could be increased in future SS versions?

[aortiz_dd]

Thank you Sergiy.
About my specific question:
“Rowcode values must be only 10 digits as max?”

If a limit exist could It be increased in future SS versions.

It is not clear for me yet.

[klaus]

@aortiz_dd

In the survey the idea is to ask for the unique registration number of the producers in the National Fruit and Vegetable Registry. These numbers are unique for each producer and have 12 digits

Even if 12 digits would be acceptable, 15 or 20 digit rowcodes would not.
Or assume you have alphanumeric registration ids…
What I did in a similar case was putting them not in a lookup table but in a variable like this:

Array.IndexOf(
new String[]{
“A49857834789757423195”,
“B12345678901234567890”,
“C30867832478573248665”
},
text1)

where text1 refers to the registration id question.
This variable returns the line where the id was found or -1 if not found.

@aortiz_dd

First we want to verify that the entered registration number exists and if it does not exist, a Warnig is activated.

check if the variable is > 1, then it exists, if it is -1 it doesn’t.

@aortiz_dd

Secondly, we want to associate surface data and number of fruit plants declared by that registration number

Put these data in a lookup table with rowcodes corresponding to the row of the id in the variable.
If the variable does not return -1, use its value to index into the lookup table.

Note: There’s a limit to how many characters you can put in an expression, so you may have to use several variables with partial registration id lists (I had to use 15 vars to fit my list).

[aortiz_dd]

Thank you for your help. I will take your advice.
But in this particular case I have 4 lookup tables full of ID numbers as rowcode and a variable as surface of plants, so I think that I will have limits if I try your idea with vars for each ID number.
My serch syntax (ID number existence ) as Warning works when I have until 10 digits in the rowcode value and the same with the syntax var that takes the value of the row variable in the lookup table ( surface associated with the ID number existing).
But when the lookup table has at least one rowcode with more than 10 digits no one syntax seems to works even if the rowcode value has less than 10 digits and exists (producers or farmers can have more than one Id number) .
It is like the presence of that value with more than 10 digits makes not work the other existing rowcode values.

[sergiy]

See the following relevant regarding the 10 digits:

Length of Numeric Fields

Hi there, We currently have a survey in field and discovered that numeric questions sometime allow 10 digits to be entered, but sometimes only allow nine digits. For example you can input 2,000,000,000 but you cannot enter 3,000,000,000. This is a repeat survey from a few years back and in the last wave we were able to enter 10 digits always and now this time there seems to be this restriction. Is this an intended feature or a bug? Thanks!

The row codes in the lookup tables are integers and follow the same constraints.

[klaus]

@aortiz_dd

so I think that I will have limits if I try your idea with vars for each ID number

I had 15,000 such IDs to verify and used 15 variables with a list of 1000 each.
This worked perfectly.