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