Why does an applymap work with a field discarded in a preceding load?

[julioarriaga]

Hi,

Thank you in advance for your help. I do not know why an applymap in a preceding load (map_Period) referencing a loaded field discarded in the preceding load (%Date_Key) still works.

Regards.

[swuehl · Accepted solution]

Because %Date_Key is part of the input table (i.e. the second table LOAD and hence can be used in any function of the preceding load, regardless if the field is part of the output table (the resulting resident table).