Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suposed no unique field name

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

Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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 *.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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 *.


talk is cheap, supply exceeds demand