Subqueries - script

[rulohx87]

Hi everybody.

i have a problem with a script. How to do it in qlikview?

SELECT COUNT(*)

FROM   ALUMNOGR A

WHERE  A.CIEGINI=2014 AND A.EAGCVE IN ('P','C')

             AND NOT EXISTS (SELECT     ''

                                        FROM   ALUMNOGR B

                                        WHERE  B.CURP = A.CURP

                                                      AND B.CIEGINI = A.CIEGINI

                                                      AND B.EAGCVE = A.EAGCVE

                                                      AND PESCVE = 2

                                                      AND ALGPROME < 6)

             AND NOT EXISTS (SELECT     ''

                                        FROM   ALUMATER C

                                        WHERE  C.CIEMINICI = A.CIEGINI

                                                      AND C.CURP = A.CURP

                                                      AND C.AMAPROMEDI < 6

                                                      AND A.PESCVE = 2)

[Anonymous]

hi raul,

if you are using jagan's script and left joining both the tables, there's no need to rename field PEsCve  to  PES_CVE,

try keeping both fields name same and try.

SCRIPT:

LOAD

    CURP,

    CiEgIni,

    PEsCve,

    EAGCve,

    AlGProme

FROM [$(vPath_EWSCE)ALUMNOGR.QVD] (qvd);

ALUMATER:

LOAD

    CURP,

    CiEMInici,

    PEsCve AS PES_CVE, // keep as PEsCve

    AMaPromedi

FROM

[$(vPath_EWSCE)ALUMATER.QVD](qvd);

UNQUALIFY * ;

Regards

Neetha