You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Management: NULL ACCOUNT Value error data load

edited Mar 9, 2020 7:00PM in Planning 10 comments

Content

Hi all

When we try to setup an SQL Script to load data using DM, we get this error: 

[TC] - [Amount=NN] PERIODO;ID_BUSINESS_UNIT;ID_SEGMENTO_COMERCIAL;ID_GRUPO;DE_GRUPO;ID_PRODUCTO;DE_PRODUCTO;ID_RED_COMERCIAL_GESTORA;ACCOUNT;_TEMG001;TIPO_SALDO
[NULL ACCOUNT VALUE] DEC-19;00814911;-999;000009000;SEGUROS HOGAR;561110001;BSSG SEGUROS PROTECCION HOGAR;00815816;;245,55;PL
[NULL ACCOUNT VALUE] DEC-19;00814911;-999;000009020;SEGUROS AUTOS;561005005;PROTECCION AUTOS;00815816;;100,88;PL
[NULL ACCOUNT VALUE] DEC-19;00814911;-999;000009030;SEGUROS EMPRESA;561005002;PROTECCION  EMPRESAS;00815816;;827,86;PL
[NULL ACCOUNT VALUE] DEC-19;00814911;-999;000009030;SEGUROS EMPRESA;561005012;PROTECCION COMERCIOS;00815816;;119,78;PL
Rows Loaded: 0
Rows Rejected: 5

--------------------------------------------------]The script is as follows: 


SQL script:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!