Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
MVP & Luminary
MVP & Luminary

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