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:
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....