Suposed no unique field name

Wed, 27 Mar 2013 11:22:07 GMT

Hi, this script has the error 'Field names must be unique within table' but I do not see any repeated field name.. where is the problem please?

APUNTES:
LOAD *,
     DATE(FECHA_CONT,'DD-MM-YY') AS FECHA,
     DAY(FECHA_CONT) AS DIA,
     MONTH(FECHA_CONT) AS MES,
     YEAR(FECHA_CONT) AS AÑO,
     DATE(MONTHSTART(FECHA_CONT),'MMM_YYYY')AS MES_AÑO,
     DIVISA & NUM(MONTHSTART(FECHA_CONT)) AS DIVDIA,
     IF (DH='H', IMPORTE*-1,IMPORTE) AS SaldoLOC,
     CTA_DESC AS DESCR_SBCTA,
     ASTO_DESC,
     APTE_DESC,
     subfield(APTE_DESC,' ',1) AS KEYWORD,
     CATEGORIA,
     NUM_ASTO,
     NUM_APTE,
DH,
CUENTA7,
SEGMENTO01 AS SOC,
SEGMENTO02 AS CTA,
SEGMENTO03 AS SBCTA,
SEGMENTO04 AS ITC,
SEGMENTO05 AS HOT,
SEGMENTO06 AS DPT,

SEGMENTO08 AS SEC,

SEGMENTO10 AS CLI

FROM
\\qlikview\Pruebas\PROY_FINANCIERO\APTE_HOTEL.QVD (qvd)WHERE SEGMENTO02>=6000 AND SEGMENTO02<=6999

Re: Suposed no unique field name

Gysbert_Wassenaar — Wed, 27 Mar 2013 11:24:35 GMT

You use * to load all fields and then rename some fields. But you also list fields without renaming them. Those are the non-unique fields since you already load them with the *.

topic Suposed no unique field name in QlikView

Suposed no unique field name

Re: Suposed no unique field name