Qlik Community

Ask a Question

Community Corner

Discussion board for questions about the Qlik Community Platform as well as general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

¿Seleccionar datos de un campo en el script?

Buenas tardes,

Me gustaría seleccionar de un campo sólo los valores que empiecen por un número determinado. ¿Cómo se podría hacer desde el script?

Gracias

3 Replies
Not applicable
Author

Prueba con algo como lo siguiente:

load

if(left(Campo,1)='3',Campo) as Campo

from ....

esto busca si el primer caracter de Campo es igual a 3 y de ser así carga Campo

Saludos

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try using this

Data:

LOAD

    *

WHERE F1 LIKE 'a*';

LOAD * INLINE [

    F1

    a

    aa

    b

    c

];

Hope this helps you.

Regards,

Jagan.

mariog
Contributor
Contributor

This is the solution. Thnak you!