Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
leenlart
New Contributor III

Inputfield with a binary load, or concatenation

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!

1 Reply

Re: Inputfield with a binary load, or concatenation

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

Community Browser