Sure... here is the code which saves to .QVD:-
Material: // Master Data: Characteristic Material
[MATERIAL] as Material,
[EANUPC] as [EAN/UPC],
[MATL_CAT] as MaterialCat,
[MATL_GROUP] as MaterialGrp,
[MATL_TYPE] as MaterialType,
[VENDOR] as Vendor,
[/BIC/Z0022] as ProdHier1,
[/BIC/Z0023] as ProdHier2,
[/BIC/Z0024] as ProdHier3,
[/BIC/Z0025] as ProdHier4,
[/BIC/ZMM_MSTAE] as XPlantStatus;
SQL Select MATERIAL
EANUPC MATL_CAT MATL_GROUP MATL_TYPE PROD_HIER VENDOR /BIC/Z0022 /BIC/Z0023
/BIC/Z0024 /BIC/Z0025 /BIC/ZMM_MSTAE
where OBJVERS = 'A'
and /BIC/Z0022 <> ''
STORE * FROM Material INTO $(vPathName)MATERIAL.QVD;
DROP TABLE Material;
Here is the code which loads into .QVW. Currently there is nothing else in this QVW:-
The 2 records in question look like this in the source BW table so the WHERE clause is being met for both:-
But in QlikView the E is dropped from one of them:-
It really has me puzzled. I have dropped a few of the fields from the view in these screen shots, but basically the two records exist in BW with only 2 fields that have a different value... the Material Code (one ends in E) and the EAN/UPC field has a different value. All other fields are the same value.
OK - I've tried a few things with the SQL statement.
If I use the following WHERE clause:-
Where MATERIAL '60693' or MATERIAL = '60693E'
I get the 2 Materials, but again the E is missing from one of them:-
But if I use this WHERE clause:-
Where MATERIAL = '60693E'
I get the 1 material with the E:-
I'm still baffled by this. Why does the E get dropped when more than one record that begins 60693 is present?
With reference to the table, it is just a standard Oracle table. The cell contents can be copied into Notepad and the cell contents for this record are 60693E.