Lookup Function

[#1]

Hi everybody.

I´d like to have a little help with this function, i´ve read a few posts but i still didnt understand.

I have this in the script, and i dont understand what it is.

IF(LEN(CUENTA)>2,lookup('CUEN_NOMBRE', 'CUENTA_AUX',LEFT(CUENTA,2), 'CUENTAS_TMP')) AS GRUPO_NOMBRE_2

Here an example of the values

CUEN_NOMBRE = activo

Cuenta_aux = 1

Cuenta= 1-1

and cuentas_tmp is a table.

Thank you all.

[alexandros17 · Accepted solution]

IF(LEN(CUENTA)>2,lookup('CUEN_NOMBRE', 'CUENTA_AUX',LEFT(CUENTA,2), 'CUENTAS_TMP')) AS GRUPO_NOMBRE_2:

Return The value in the field CUEN_NOMBRE From the table CUENTAS_TMP Where the value Left(CUENTA,2) (first 2 characters) match in the field CUENTA_AUX

[#3]

Thank you! Now i have a little doubt about this parte.

Where the value Left(CUENTA,2) (first 2 characters) match in the field CUENTA_AUX

What do you mean with match? that there are the same values? sory but i don´t have a good english

Cheers.

[alexandros17]

Yes , the first time they have the same values you have the field returned.

[#5]

Thanks