Inputfield with a binary load, or concatenation

leenlart — Tue, 27 Nov 2018 08:13:04 GMT

Hello,

I have a qvw (we'll call it qvwFinal) that is loaded by a binary load on what we'll call qvwTechnical. I have been asked to add an inputfield on a field of what we'll call Table1.

I was able to add the inputfield correctly in my qvwTechnical, but when I do the binary load on qvwFinal I loose the inputfield functionality and the field is populated with incremental numbers. (I've seen multiple posts related to this problem.)

So I tried saving Table1 as a qvd and dropping it from my qvwTechnical. I then load Table1 in qvwFinal with the inputfield after the binary load. My inputfield works correctly and the field is populated correctly. However, I have a star schema and in the middle is the Pivot table. For the users to be able to query the Table1, I need to concatenate the key values to Pivot table. When I do this, I loose my inputfield once again.

I've read that joining can cause inputfields to not work properly. Could this be the reason ?

Here is this part of the load script that comes after the binary load:

INPUTFIELD PROVISION_CGI;

Provisions:
LOAD %PROV_ID,
CSOC_PROV,
CETAB_PROV,
CDEPOT_PROV,
CEMPL_PROV,
CART_PROV,
LOT_PROV,
DateProvision,
%DATEPROV,
QTEBASE1_PROV,
CUNITEBASE1_PROV,
%SOC_ETAB_ART_LOT_PROV,
%SOC_ARTICLE_PROV,
CSTATUT_PROV,
LSTATUT_PROV,
DateStatut,
DateDLUO,
DateDLC,
DateDLS,
VALEUR_PROV,
TXPROVISION_PROV,
PROVISION,
PROVISION_CGI
FROM
$(vRepQVD)\Provisions_gastro_calcules.qvd (qvd);

Concatenate (Pivot)
LOAD
%PROV_ID,
%SOC_ARTICLE_PROV as %SOC_ARTICLE_ID,
CSOC_PROV as CSOC,
CETAB_PROV as CETAB,
CART_PROV as %ARTICLE_ID,
LOT_PROV as LOT,
CDEPOT_PROV as DEPOT,
CEMPL_PROV as CEMPL,
%DATEPROV as %DATE_ID
resident Provisions;

Could it be that I have multiple keys? And how can I go about checking this?

Any other ideas of how to go about this? I'm a bit of a novic....

Thanks!

Re: Inputfield with a binary load, or concatenation

marcus_sommer — Tue, 27 Nov 2018 14:49:49 GMT

Maybe loading resident from the binary is an alternatively:

BINARY ...;

INPUTFIELD PROVISION_CGI;

temp: load *, PROVISION_CGI resident Provisions;

drop tables Provsions;
rename temp to Provisions;

- Marcus

topic Inputfield with a binary load, or concatenation in QlikView

Inputfield with a binary load, or concatenation

Re: Inputfield with a binary load, or concatenation