Concatenate

[absekrafi]

Hi Qlikview experts,

I am new to Qlikview and I have an issue with "concatenate" function.

I sepearted the code of my concatenate function to a sepearte project, every thing work perfecly but when I merge the "concatenate" code in to my project some fields have null values. the fields are CODUSN, TRANSACTION_DATE, CODEART, CODESART, ....

Enclosed the code (it is the same in both cases) but the result is different:

Directory;

PRODUCTION_REDRESS:

LOAD CODEART,

     CODESART,

     CODUNT,

     CODUSN,

     DATPROD AS TRANSACTION_DATE,

     OBSERVATION,

     QTEPROD,

     STOCKFM,

     STOCKFNM,

     STOCKPHY,

     TYPEART

FROM

[..\QVD\PRODUCTION.qvd]

(qvd);

Directory;

CONCATENATE (PRODUCTION_REDRESS)

LOAD

CODPROD AS CODEART,

CODESART,

     CODU AS CODUNT,

     CODUSN,

     DATRED AS TRANSACTION_DATE,

     QTERED AS QTEPRODRED

FROM

[..\QVD\REDUSN_U.qvd]

(qvd);

STORE PRODUCTION_REDRESS into [..\QVD\PRODUCTION_REDRESS.qvd] (qvd);

DROP Table PRODUCTION_REDRESS;

Directory;

PRODUCTION_REDRESS:

LOAD CODEART,

     CODESART,

     CODUNT,

     CODUSN,

     TRANSACTION_DATE,

     OBSERVATION,

     QTEPROD,

     STOCKFM,

     STOCKFNM,

     STOCKPHY,

     TYPEART,

     QTEPRODRED,

     NumSum(QTEPRODRED, QTEPROD) AS QUANTPROD

FROM

[..\QVD\PRODUCTION_REDRESS.qvd]

(qvd);

STORE PRODUCTION_REDRESS into [..\QVD\PRODUCTION_REDRESS.qvd] (qvd);

Please help to understand why these fields have empty values.

Thank you in advance,

Kind regards.

Abdallah

[absekrafi]

QTEPROD is a field of PRODCTION Table

QTERED AS QTEPRODRED is a field of REDUSN_U Table

And QUANTPROD is the Sum of both previous fields: NumSum(QTEPRODRED, QTEPROD) AS QUANTPROD

Thanks in advance

[shiveshsingh]

Then u can join them instead, on the basis of matching fields, you'll get other columns too.

Then you can get the derived field in expression.

[absekrafi]

Thank you Shivesh,

I did a Join on both Tables and it's working.

When we use concatenate?

[shiveshsingh]

It depends on the requirement, i generally use it for concatenating several tables to create fact table..

please check in qlik help..it will give u a bigger picture