Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 *.
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 *.