I have a very strange problem in my script: A few records disappear for no apparent reason - even worse:
=> In one and the same LOAD statement, I load a field twice - once, all is ok - the other time, certain values are missing...
I will for now just post the piece of the script where I have a problem as I'm absolutely sure the problem is in that part.
// Here I load a filtering table to load only those values of PERSEH that I need for my chart Filter_emps: LOAD PERSEHasVorg_einh, PERSEHasVorg FROM [\\rgb1sfs201\Regensburg\Common\03-HR\adicom_Vorgängereinheiten.xls] (biff, embeddedlabels, tableis [Gesamtmapping$]);
As you see, this is a RESIDENT LOAD, I have my base_load from the database in an earlier part of the script. The relevant point is this field "Vorgängereinheit": I load this twice because once it is being used as a key to link to "Filter_emps" and the other one is used for further processing.
The strange thing is this: In the field "Vorg_einh" (the key_field), certain values are included - all values are there actually. When, in the table "Filter_emps", I select those values in the field "Vorg", the field "Vorg_einh" follows that selection, the values are there.
<=> The field "Pers_einh" (the name is used for the first time in this table) does not follow the selection, the values are NOT there.
Simple. The field Vorg_einh contains all values from both Filter_emps and MA_Grunddaten_#3_pre. Pers_einh contains only the values from MA_Grunddaten_#3_pre. In sheet objects it doesn't matter which table the value came from. There are only fields with values. The tables you created in the script are just names that have no meaning or purpose anymore in sheet objects.