How complete empty values?

[alejortizp]

Good day,

I am trying to fill the empty values with "Sin Datos" in the senteces of the main script SET NULLINTERPRET="Sin Datos"; or SET NULLDISPLAY="SIN DATO"; but still appearing empty values.

Thanks if you give me a light.

[PabloTrevisan]

Hi Alejandro.

NULLASVALUE yourfield;

set NullValue='SIN DATO';

[alejortizp]

Hi pablo,

I dont know why doesnt work. That sentences is in the extraccion or the transformation?

This is my code:

EXTRACCION SCRIPT:

[usuarios]:

NULLASVALUE Regional;

set NullValue='SIN DATO';

LOAD

[Código de municipio de residencia del usuario] ,

[Descripción Mpio],

[Regional],

    [Año de reporte],

[Identificación BDUA del usuario],

[Costo total anual de la  prestación de servicios al usuario.]

FROM [lib://Ejercicio antioquia con georeferenciacion/usuarios costosos.xlsx]

Store usuarios into Lib://qvdsmapa/municipioantioquia.qvd;

TRANSFORMATION SCRIPT:

usuarios:

NullAsValue Regional;

set NullValue='SIN DATO';

LOAD

    "Código de municipio de residencia del usuario",

    "Descripción Mpio",

    Regional,

    "Año de reporte",

    "Identificación BDUA del usuario",

    "Costo total anual de la  prestación de servicios al usuario."

FROM [lib://qvdsmapa/usuarios.qvd]

(qvd);

[PabloTrevisan]

Could You send me your .qvf and a small .qvd to test ?

[alejortizp]

Hi Pablo,

This is a sample file in which there is a sheet with a bar graph and in the script is the code that I used. Thank you very much if you help me to complete the null values with any field that I specify.

[PabloTrevisan]

Honestly, it seems to me that it's rubbish in the base, since there is nothing besides the 'cost' in this line where the fields are null, isn't really working ... but is it interesting to go back this line?

[PabloTrevisan · Accepted solution]

Try in script

NULLASVALUE *;

set NullValue='SIN DATO';